ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Cross platform worksheet issues (https://www.excelbanter.com/excel-worksheet-functions/46560-cross-platform-worksheet-issues.html)

Wallace, William

Cross platform worksheet issues
 
When Windows users create a worksheet that uses the WORKDAY function from
the analysis toolpak for VBA, that document frequently returns the #NAME
error in the cells referencing the function when the document is opened by
Mac users. Our Macs are running Office 2004 under OS X 10.3.9 with the
Analisys toolpak for VBA enabled. Anybody else seen this issue? Know how to
resolve it?

Thanks.
--
Bill Wallace
Macintosh Technical Specialist
Wright Group/McGraw-Hill
130 East Randolph, Suite 400
Chicago, IL 60601
312-233-6794



Gary L Brown

Is 'Analysis ToolPak' (as well as 'Analysis ToolPak for VBA') checked? They
are 2 different add-ins. One works with worksheets and the other in VBA.
HTH,
--
Gary Brown

If this post was helpful, please click the ''''Yes'''' button next to
''''Was this Post Helpfull to you?".


"Wallace, William" wrote:

When Windows users create a worksheet that uses the WORKDAY function from
the analysis toolpak for VBA, that document frequently returns the #NAME
error in the cells referencing the function when the document is opened by
Mac users. Our Macs are running Office 2004 under OS X 10.3.9 with the
Analisys toolpak for VBA enabled. Anybody else seen this issue? Know how to
resolve it?

Thanks.
--
Bill Wallace
Macintosh Technical Specialist
Wright Group/McGraw-Hill
130 East Randolph, Suite 400
Chicago, IL 60601
312-233-6794





All times are GMT +1. The time now is 04:42 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com