Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming,microsoft.public.excel
|
|||
|
|||
Help! Excel 2007 and Excel 2003 are not compatible?
Help! Excel 2007 and Excel 2003 are not compatible?
Hi all, I just don't understand this. I have a Excel sheet which was created in Excel Xp 2003. And it is full of calculations. When I open it in Excel 2007, And press SHIFT+F9, it always gives "NO-CELL" error. Basically it doesn't run at all. But when I go to each cell, and following the logical dependency, and refresh/recalculate each cell one by one, then the results are correct... But there are so many cells and manually going through them are infeasbile. What can I do now? Can anybody help me? Thanks! |
#2
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming,microsoft.public.excel
|
|||
|
|||
Help! Excel 2007 and Excel 2003 are not compatible?
Try rebuilding the dependency tree with CTRL+ALT+SHIFT+F9
-- Kind regards, Niek Otten Microsoft MVP - Excel "LunaMoon" wrote in message ... | Help! Excel 2007 and Excel 2003 are not compatible? | | Hi all, | | I just don't understand this. | | I have a Excel sheet which was created in Excel Xp 2003. And it is | full of calculations. | | When I open it in Excel 2007, | | And press SHIFT+F9, it always gives "NO-CELL" error. | | Basically it doesn't run at all. | | But when I go to each cell, and following the logical dependency, and | refresh/recalculate each cell one by one, | | then the results are correct... | | But there are so many cells and manually going through them are | infeasbile. | | What can I do now? | | Can anybody help me? | | Thanks! |
#3
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming,microsoft.public.excel
|
|||
|
|||
Help! Excel 2007 and Excel 2003 are not compatible?
I think I tried it before... no use...
but let me try again... On Aug 5, 2:10*pm, "Niek Otten" wrote: Try rebuilding the dependency tree with CTRL+ALT+SHIFT+F9 -- Kind regards, Niek Otten Microsoft MVP - Excel "LunaMoon" wrote in ... | Help! Excel 2007 and Excel 2003 are not compatible? | | Hi all, | | I just don't understand this. | | I have a Excel sheet which was created in Excel Xp 2003. And it is | full of calculations. | | When I open it in Excel 2007, | | And press SHIFT+F9, it always gives "NO-CELL" error. | | Basically it doesn't run at all. | | But when I go to each cell, and following the logical dependency, and | refresh/recalculate each cell one by one, | | then the results are correct... | | But there are so many cells and manually going through them are | infeasbile. | | What can I do now? | | Can anybody help me? | | Thanks! |
#4
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming,microsoft.public.excel
|
|||
|
|||
Help! Excel 2007 and Excel 2003 are not compatible?
No use... it shows a lot of NOCELL errors and a pop up window showing
"stale object handle" error... On Aug 5, 2:40*pm, LunaMoon wrote: I think I tried it before... no use... but let me try again... On Aug 5, 2:10*pm, "Niek Otten" wrote: Try rebuilding the dependency tree with CTRL+ALT+SHIFT+F9 -- Kind regards, Niek Otten Microsoft MVP - Excel "LunaMoon" wrote in ... | Help! Excel 2007 and Excel 2003 are not compatible? | | Hi all, | | I just don't understand this. | | I have a Excel sheet which was created in Excel Xp 2003. And it is | full of calculations. | | When I open it in Excel 2007, | | And press SHIFT+F9, it always gives "NO-CELL" error. | | Basically it doesn't run at all. | | But when I go to each cell, and following the logical dependency, and | refresh/recalculate each cell one by one, | | then the results are correct... | | But there are so many cells and manually going through them are | infeasbile. | | What can I do now? | | Can anybody help me? | | Thanks! |
#5
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming,microsoft.public.excel
|
|||
|
|||
Help! Excel 2007 and Excel 2003 are not compatible?
Can anybody help?
Cannot imagine that I cannot use the old sheet in 2007... this is miserable.... On Aug 5, 2:48*pm, LunaMoon wrote: No use... it shows a lot of NOCELL errors and a pop up window showing "stale object handle" error... On Aug 5, 2:40*pm, LunaMoon wrote: I think I tried it before... no use... but let me try again... On Aug 5, 2:10*pm, "Niek Otten" wrote: Try rebuilding the dependency tree with CTRL+ALT+SHIFT+F9 -- Kind regards, Niek Otten Microsoft MVP - Excel "LunaMoon" wrote in ... | Help! Excel 2007 and Excel 2003 are not compatible? | | Hi all, | | I just don't understand this. | | I have a Excel sheet which was created in Excel Xp 2003. And it is | full of calculations. | | When I open it in Excel 2007, | | And press SHIFT+F9, it always gives "NO-CELL" error. | | Basically it doesn't run at all. | | But when I go to each cell, and following the logical dependency, and | refresh/recalculate each cell one by one, | | then the results are correct... | | But there are so many cells and manually going through them are | infeasbile. | | What can I do now? | | Can anybody help me? | | Thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2007 Pivot Tables compatible with 2003 | Excel Worksheet Functions | |||
Excel 2007 versus Excel 2003 & Excel 97-2003 fully compatible | Excel Worksheet Functions | |||
Excel 2007 how to create charts compatible with 2003? | Charts and Charting in Excel | |||
Help! Excel 2007 and Excel 2003 are not compatible? | Excel Discussion (Misc queries) | |||
How to save Excel 2007 compatible with excel 2003 | Excel Discussion (Misc queries) |