0
How do you deal with an error message pivot table created in a later version of Excel and can not be updated?
Wiki User
∙ 14y ago
Unfortunatly, you will need to find a more current version of Excel to access the pivot table. After you do, save the file in compatible format for older version of Excel. Then you should be able to open the file and update the pivot table. However, if someone created the pivot table with Excel 2007 and used any of the new features, those features will be lost when you save in Excel 2003 format.
See related links for a method to change the default for Excel 2007 to save pivot tables in the older classic format for Excel 2003 and earlier.
Wiki User
∙ 14y ago
Add your answer:
Earn +20 pts
What are the various versions of Microsoft Excel?
( There was no version 1) Excel 2.0 for Windows Excel 3.0 Excel 4.0 Excel 5.0 No version 6 Excel for Windows 95 (version 7.0) in Office 95 Excel 97 (version 8.0) in Office 97. Excel 2000 (version 9.0) in Office 2000 Excel 2002 (version 10) in Office XP Office Excel 2003 (version 11) in Office 2003 Office Excel 2007 (version 12) in Office 2007 No version 13 Excel 2010 (version 14) in Office 2010 Excel 2013 (version 15) in Office 2013
Does excel does workbook have the file extension xml?
No. It is xlsx or xls depending on the version of Excel you have.No. It is xlsx or xls depending on the version of Excel you have.No. It is xlsx or xls depending on the version of Excel you have.No. It is xlsx or xls depending on the version of Excel you have.No. It is xlsx or xls depending on the version of Excel you have.No. It is xlsx or xls depending on the version of Excel you have.No. It is xlsx or xls depending on the version of Excel you have.No. It is xlsx or xls depending on the version of Excel you have.No. It is xlsx or xls depending on the version of Excel you have.No. It is xlsx or xls depending on the version of Excel you have.No. It is xlsx or xls depending on the version of Excel you have.
How you can open my Excel files?
Check which version of Excel you have (maybe 2003?) and make sure the file was created on the same version or earlier. If someone has sent you a file created on Excel 2007, you can bang on the keyboard all you want but it won't open if you have an older version. Phil If you are getting problem in opening excel file then there might be the problem in excel file. The problem may be corruption in the MS Office software. Therefore to resolve the problem you can use repair excel file software. As such it is very helpful in resolving the problem.
How do you find what version of Microsoft Excel you have?
Go to the Help menu and look at the About option which will tell you. The version of Excel you have is linked to the version of Office you have. If you know what version of Office you have, then you know what version of Excel you have.
When Microsoft Excel is a new version out?
Excel 2010 is the latest version. A 2012 version is under development.
What is an item that can be automatically updated within Excel?
formula
Where was Microsoft Excel created?
Microsoft released the first version of Excel for the Mac in 1985, and the first Windows version (numbered 2.05 to line up with the Mac and bundled with a run-time Windows environment) in November 1987.
To what does a REF error message refer?
A REF error message is a message that is used in the Windows Excel program, part of the Office package, in that there is an error input or output in an excel cell data pack.
Which is the last cell in Ms-Excel?
That will depend on your version. Up to version 2003 it was IV65536. In Excel 2007 and later versions it is XFD1048576.
What is the Microsoft version of Excel before 2013 came out?
Microsoft Excel 2010.
What does excel displays error message that begins with?
An error message begins with the pound sign (#).
When was Lotus Excel created?
Lotus Excel was created in 1982.
