#NAME? when going from Excel 2007 to Excel 2004

[clmatthews]

Whenever Mac users open files, table have #NAME? in them. Tried
recalculating sheet - doesn't help. Also, once Mac users save file - same
thing occurs back on PC 2007 users. Any other suggestions?

 

[Jan Karel Pieterse]

Hi Clmatthews,

Whenever Mac users open files, table have #NAME? in them. Tried
recalculating sheet - doesn't help. Also, once Mac users save file - same
thing occurs back on PC 2007 users. Any other suggestions?

Sound slike the sheet uses a function Excel 2004 doesn't recognise
automatically. May be a function that used to be part of the Analysis Toolpak
addin. Excel 2007 has those built-in and 2004 does not. Try installing the ATP
in 2004 and F2-entering the offending formulas. A global search and replace,
searching for = and replacing with = might also do the trick.

Regards,

Jan Karel Pieterse
Excel MVP
http://www.jkp-ads.com
Member of:
Professional Office Developer Association
www.proofficedev.com

 

[clmatthews]

I tried adding ATP to 2004, now everything looks good on Mac side but once I
save it - 2007 still has #NAME? error. Do I need to double check the ATP
addin for 2007 as well or is there something else?

 

[Jan Karel Pieterse]

Hi Clmatthews,

I tried adding ATP to 2004, now everything looks good on Mac side but once I
save it - 2007 still has #NAME? error. Do I need to double check the ATP
addin for 2007 as well or is there something else?

I'm afraid this is a problem with the ATP functions that wont go away without
writing VBA.

You'd need code for 2004 that checks availability of the ATP and for both
versions that does a global S&R replacing = with = in all worksheets.

Regards,

Jan Karel Pieterse
Excel MVP
http://www.jkp-ads.com
Member of:
Professional Office Developer Association
www.proofficedev.com

 

[clmatthews]

Hi Clmatthews,


I'm afraid this is a problem with the ATP functions that wont go away without
writing VBA.

You'd need code for 2004 that checks availability of the ATP and for both
versions that does a global S&R replacing = with = in all worksheets.

Regards,

Jan Karel Pieterse
Excel MVP
http://www.jkp-ads.com
Member of:
Professional Office Developer Association
www.proofficedev.com

If I upgrade Macs to 2008, will this solve the issue?

 

[Jan Karel Pieterse]

Hi Clmatthews,

If I upgrade Macs to 2008, will this solve the issue?

No, even worse, you'll loose VBA!

Regards,

Jan Karel Pieterse
Excel MVP
http://www.jkp-ads.com
Member of:
Professional Office Developer Association
www.proofficedev.com