#NAME? when going from Excel 2007 to Excel 2004

  • Thread starter Thread starter clmatthews
  • Start date Start date
C

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?
 
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 said:
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?
Click to expand...
 
Back
Top