Sending files that use analysis tools functions from Max Excel to Windows Excel

P

piven.jeremy

I am trying to send a spreadsheet that uses analysis toolpak functions
(e.g., edate, xirr) from a mac user to a Windows user. I have never
had a problem before if the recipient had the add-in enabled, but for
some reason I am having problems.

It looks like the problem is that the file contains links to the add-in
which would not be compatible. I was able to edit the link when I sent
it to a Windows box, but the person I am sending it to cannot seem to
get it to work. Any ideas? Would dual format work?
 
J

JE McGimpsey

[email protected] said:
I am trying to send a spreadsheet that uses analysis toolpak functions
(e.g., edate, xirr) from a mac user to a Windows user. I have never
had a problem before if the recipient had the add-in enabled, but for
some reason I am having problems.

It looks like the problem is that the file contains links to the add-in
which would not be compatible. I was able to edit the link when I sent
it to a Windows box, but the person I am sending it to cannot seem to
get it to work. Any ideas? Would dual format work?
Click to expand...

Dual format is unlikely to help - MacXL98/01/v.X/04 and WinXL97/00/02/03
file formats are identical.

How are you calling XIRR? If you're calling it as

=XIRR(arg1,arg2...)

you shouldn't need to do anything - if the WinXL user has the add-in
enabled, XL will use ATP's XIRR automatically.

What did you do to edit the link?
 
P

piven.jeremy

For XIRR, I am calling it as XIRR(Values,Dates). It also uses EDate.

To edit the links, I notice by sending it to a Windows machine that the
file had links. I checked the links and saw that it was linking to the
Analysis Toolpak on my machine. I changed it by going to Edit:Links
and then Change Source and set it to the Analysis Toolpak and it seemed
to work, but does not work on the other machine.
 
J

JE McGimpsey

[email protected] said:
For XIRR, I am calling it as XIRR(Values,Dates). It also uses EDate.

To edit the links, I notice by sending it to a Windows machine that the
file had links. I checked the links and saw that it was linking to the
Analysis Toolpak on my machine. I changed it by going to Edit:Links
and then Change Source and set it to the Analysis Toolpak and it seemed
to work, but does not work on the other machine.
Click to expand...

Hmmm....

I don't use ATP functions very often, but I've never noticed that using
an ATP function creates a link. Do the links show up as links in MacXL
(Edit/Links...)?

What happens if you, in WinXL, break the links then re-enter the
function?

I suppose it's possible that your workbook has become corrupted. Try
copy/pasting your data to a fresh new workbook.
 
P

piven.jeremy

Yes, it does show up as Edit/Links in MacXL, which I have never seen
before. Just for giggles, I saved the file under another name and
broke the links. Nothing bad happened, so that might do the trick.
 
Top