PC Spreadsheet to Excel Errors?

[jerry.wattenberg]

I just received a spreadsheet from a PC, and the instructions told me
to instaill the analysis toolpack, analysis toolpack VBA and zCalc
Function Library - I couldnt find the last one, and now the spreasheet
cannot calculate dates or holidays. What is the solution (it works on
a PC that my client has!).

Thank You

 

[Mike Middleton]

One possible solution is to browse to www.google.com, and search for "zcalc
function library" (without the quotes). Have you done that?

- Mike

 

[JE McGimpsey]

I just received a spreadsheet from a PC, and the instructions told me
to instaill the analysis toolpack, analysis toolpack VBA and zCalc
Function Library - I couldnt find the last one, and now the spreasheet
cannot calculate dates or holidays. What is the solution (it works on
a PC that my client has!).

The most likely possibility for the zCalc Function library seems to be a
commercial add-in for WinXL:

http://www.fasttax.thomson.com/zcalc_downloads.asp

The download's an .exe file and requires a registration code to install,
so I wasn't able to test it or see whether it works for MacXL (though
I'd tend to bet against it).

 

[Geoff Lilley]

The most likely possibility for the zCalc Function library seems to be a
commercial add-in for WinXL:

http://www.fasttax.thomson.com/zcalc_downloads.asp

The download's an .exe file and requires a registration code to install,
so I wasn't able to test it or see whether it works for MacXL (though
I'd tend to bet against it).

Question - do you get a prompt when you open the file saying that it
has links to other files? If so, you can choose "Edit Links" and then
click on "Break Link." In terms of calculating dates and holidays,
you will probably have to use other means, such as the Analysis
Toolpak's function NETWORKDAYS.

HTH
Cheers
Geoff