Windows Error Fixer: How to Fix - 2003 to 2007 upgrade query on columns and data problem?

Tuesday, March 15, 2016

How to Fix - 2003 to 2007 upgrade query on columns and data problem?

2003 to 2007 upgrade query on columns and data problem

Original Title: 2003 TO 2007 UPGRADE QUERY ON COLUMNS AND DATA PROBLEM
Hello,
I have just moved from excel 2003 to 2007 and I am having a problem with pivot tables. In 2003 I would grab a heading and drop to row, grab another and drop to columns, and then grab the same heading (as the column heading) and drop to the data section
to give me the results I need.
However in 2007 I can't seem to use the same data for the column headings as well as the data values. Once you have put the rows & columns where you want them you cant seem to use the same information in the values section. Am I missing something really
simeple? How do you do this when it was so simple in 2003?
This is an extreamely important table that I need to do this morning so would be extreamely grateful for any help.
regards
carrach

Solutions to the Problem 2003 to 2007 upgrade query on columns and data problem

Download Error Fixer (Free)

no - it is with all excel worksheets but I have found my own answer. If I grab the heading from column labels and drag slightly to the Right and down it will then drop into the values section of the fields list.
Hope this helps others

Boot in Safe Mode:

Open Run command as previously described
Type MSConfig
Click on Boot tab
Tick Safe boot in Boot option
Select Network
Click Apply and OK
Reboot your system

Your system will boot in Safe mode with Networking. You may now try and open Windows Store and should not see any errors.

Another Safe way to Fix the Problem: 2003 to 2007 upgrade query on columns and data problem:

How to Fix 2003 to 2007 upgrade query on columns and data problem with SmartPCFixer?

1. Download SmartPCFixer . Install it on your system. Click Scan, and it will perform a scan for your computer. The errors will be shown in the list.

2. After the scan is finished, you can see the errors and problems need to be fixed. Click Fix All.

3. The Repair part is finished, the speed of your computer will be much higher than before and the errors have been removed. You can also use other functions in this software. Like dll downloading, windows updating and print spooler error repair.