2003 to 2007 upgrade query on columns and data problem
Original Title: 2003 TO 2007 UPGRADE QUERY ON COLUMNS AND DATA PROBLEM
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.
Solutions to the Problem 2003 to 2007 upgrade query on columns and data problem
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.
Related: 1327 Invalid Drive Z Error Code 80004004 Error Code 137 80072ee7 Fix 3315 Error 26 3213 1726 0X6be Error Code 1393 Acaptuser32 dll Error 3050 Biosinfo dll,Fast Solution to Fix Error 1017 Received Logging On To The Standby Error,Installation Error 1706 Error Fixer,Loopback Failure Error - How to Fix,How to Fix Pro Registry Cleaner Error,How to Fix Win 7 Installation Error Code: 0x800705070 Error Quickly
Read More: 2010 word starter will not shut down,Troubleshooting:12gb of shared graphic memory GONE !,Fast Solution to Problem: 2 screens at the same time,2011 windows live messenger yüklenmiyor [Solved],Troubleshoot:2011 Word for Mac - My center alignment and all alignments for some reason, no matter what will move my whole paper instead of the highlighted text,IE 8: Can't Send Page by Email AND Can't Send Link by Email,I can't connect to yahoo.com for online gaming after installing ex9 is there a problem?,c drive says full with 58gb and drive d has 219gb how to fromat drive c for more gb,Automatic Spelling Correction in MS Excel 2007,Attempting to install a financial program and getting error with regsvr32