Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Using Spreadsheet created in Excel 2007 in Excel 2003
I am trying to use a spreadsheet that was created in Excel 2007. I am
currently using Excel 2003. The Spread sheet is designed with formulas and macros where if you enter or change numbers in a few cells, it recalculates other pieces of the spreadsheet. Instead of getting a number or percentage or whatever is supposed to be there, I get #NAME?. This happens in several cells. I have checked and the formulas appear as though they should work. I know the file has not been corrupted or anything. I have transferred it to a different computer that uses Excel 2007 and it works there. I have tried several things including: -lowering the security settings on the macros, saving, and closing. Doesn't work. -I have tried copying the entire spreadsheet to a new one. 7 tabs of info info. Doesn't work. -I have gone to the Microsoft website and done installed all the latest updates. I am currently on service pack 3 for excel. There has to be an easy way to convert this file back to Excel 2003 so that it will work. What is the solution for this? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Using Spreadsheet created in Excel 2007 in Excel 2003
Hi,
try this open the spreadsheet and do save as, choose excel -97-2003, hope this helps "Mike" wrote: I am trying to use a spreadsheet that was created in Excel 2007. I am currently using Excel 2003. The Spread sheet is designed with formulas and macros where if you enter or change numbers in a few cells, it recalculates other pieces of the spreadsheet. Instead of getting a number or percentage or whatever is supposed to be there, I get #NAME?. This happens in several cells. I have checked and the formulas appear as though they should work. I know the file has not been corrupted or anything. I have transferred it to a different computer that uses Excel 2007 and it works there. I have tried several things including: -lowering the security settings on the macros, saving, and closing. Doesn't work. -I have tried copying the entire spreadsheet to a new one. 7 tabs of info info. Doesn't work. -I have gone to the Microsoft website and done installed all the latest updates. I am currently on service pack 3 for excel. There has to be an easy way to convert this file back to Excel 2003 so that it will work. What is the solution for this? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Using Spreadsheet created in Excel 2007 in Excel 2003
The #NAME? error is telling us that XL isn't recognizing some part of the
formula, be it a 2007 exclusive formula (such as SUMIFS/COUNTIFS) or a UDF. Is there a way you could give us an example of the formula, so we can see what your are trying to do? We may be able to suggest an alternative formula that will work in 2003. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Mike" wrote: I am trying to use a spreadsheet that was created in Excel 2007. I am currently using Excel 2003. The Spread sheet is designed with formulas and macros where if you enter or change numbers in a few cells, it recalculates other pieces of the spreadsheet. Instead of getting a number or percentage or whatever is supposed to be there, I get #NAME?. This happens in several cells. I have checked and the formulas appear as though they should work. I know the file has not been corrupted or anything. I have transferred it to a different computer that uses Excel 2007 and it works there. I have tried several things including: -lowering the security settings on the macros, saving, and closing. Doesn't work. -I have tried copying the entire spreadsheet to a new one. 7 tabs of info info. Doesn't work. -I have gone to the Microsoft website and done installed all the latest updates. I am currently on service pack 3 for excel. There has to be an easy way to convert this file back to Excel 2003 so that it will work. What is the solution for this? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
use check box created in Excel 2003 opened in Excel 2007 | Excel Worksheet Functions | |||
Linked text boxes created in Excel 2007 are blank in Excel 2003? | Charts and Charting in Excel | |||
cannot view chart created in excel 2003 in excel 2007 | Charts and Charting in Excel | |||
Charts created in Excel 2003 are not showing up in excel 2007 | Charts and Charting in Excel | |||
Excel 2007, why is it slow opening files created in Excel 2003? | Excel Discussion (Misc queries) |