 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Excel Errors / May 2008#NAME? when going from Excel 2007 to Excel 2004
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? 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 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? > Hi Clmatthews, > [quoted text clipped - 16 lines] > Professional Office Developer Association > www.proofficedev.com 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 > Hi Clmatthews, > [quoted text clipped - 18 lines] > > If I upgrade Macs to 2008, will this solve the issue? 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 |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.