ExcelBanter - Help! Excel 2007 and Excel 2003 are not compatible?

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Help! Excel 2007 and Excel 2003 are not compatible? (https://www.excelbanter.com/excel-discussion-misc-queries/197645-help-excel-2007-excel-2003-not-compatible.html)

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!

Help! Excel 2007 and Excel 2003 are not compatible?

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!

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!

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!