Excel - Analysis ToolPak - Versions

[Althor33]

Hello,

We have spreadsheets going through different users with different versions of Excel (XP, 2003).

The links to the Analysis Toolpak varies from versions.

C:\Program Files\Microsoft Office\OFFICE10\Library\Analysis
C:\Program Files\Microsoft Office\OFFICE11\Library\Analysis
depending on the version...

with =WEEKNUM(), the formula does not work in cross versions when passing the worksheet around.

Besides modifying manually the link in the edit/links menu, any ideas ?

Thanks

 

[GlennUK]

Do you mean that it gives different results? If so, you could write your own UDF embedded in each workbook instead.

Cheers, Glenn.

Did you hear about the literalist show-jumper? He broke his nose jumping against the clock.

 

[KenWright]

Be interested to know what doesnt work. Makes no difference with the test data I used flipping from one version to the other.

Regards
Ken...........

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission
----------------------------------------------------------------------------

 

[Althor33]

The problem is quite simple.
User A (with Excel 2002) makes a spreadsheet with the =weeknum(a1) in B1. Whatever the result, i works.
User A sends the file to user B.
User B opens the file (With Excel 2003) and has #NAME in the B1 cell.
User B relinks the ATPVBAEN file to his path (Office11) and it works.

Reverse has same effect (UserB to User A) in new file.

Thanks for you help

 

[GlennUK]

Are you saying that user B has the Analysis Toolpak Add-in ticked, and the cell result is #NAME?

Cheers, Glenn.

Did you hear about the literalist show-jumper? He broke his nose jumping against the clock.

 

[Althor33]

Glenn,

Absolutely.

Both users have the Add-in tikced. (Checked, double-checked, removed, reinstalled....the works....)

Both can WRITE their own formula (=weeknum())in the spreadsheet BUT!, when transfered to the other user/version, it does not work...

Althor33

 

[xlhelp]

I realize this is silly, but have you tried with both Analysis Toolpak and Analysis Toolpak VBA added in?

Member- AAAA Association Against Acronym Abusers

 

[Althor33]

Thanks xlhelp.
Your solution is not silly at all.
Did try it. No avail.

One more detail (although the original post does talk about it), when the file that comes from 2002 is open in 2003, the cell with the formula gives a #NAME?.
When looking at the content of the cell, it says:
='C:\Program Files\Microsoft Office\Office10\Library\Analysis\ATPVBAEN.XLA'!weeknum(a1)

Still searchin'...