Fromula corruption after transfer

[smcelv]

Hi guys
Could anyone explain why this happens?

A formula in a given cell reads as " =WEEKNUM(ER3)-1"
When transferred to a new PC it becomes -
='C:\Program Files\Microsoft Office\OFFICE11\LIBRARY\Analysis\ATPVBAEN.XLA'!WEEKNUM(ER3)-1

Can I prevent this happening?

 

[njimack]

You need to activate the Analysis Toolpak (Tools>Add-ins)

 

[smcelv]

Already have njimack but every time I take the workbook into work I have the same problem. The analysis toolpak is installed on my work PC as well ******** type=text/javascript> vbmenu_register("postmenu_2827757", true); *********>

 

[njimack]

In that case, it's probably installed in a different location. I think you need to uncheck it in the list of add-ins, and then ensure the .xla file is in exactly the same location on both machines.

 

[smcelv]

Will check that out.
Thank you for your help