List separators ; becoming \ (only in formulas in names) when opening file on another PC

  • Thread starter Thread starter Pierre Decuyper
  • Start date Start date
P

Pierre Decuyper

Hi,

I've got a worksheet for analysing data's to be shown in XY scatters graphs.
I used Tushar Mehta's excellent add-in to keep the scale limits updated all
the time.
The problem is: it works perfectly on my PC and does not work on other PC in
my company:
The names used to define the values giving the scale(s) contain formulas in
which the list separators ";" have been replaced by a (funny?) "\" (yes,
backslash!!!).
I've checked the regional settings, list separators,... They are the same on
the two other PCs I checked.
Can anybody help ???
Thks in advance
 
How are you calculating the contents of the cells that contain the min
and max values? My guess is that there is some formula in those cells.
If so, those formulas use an add-in on your computer (maybe, it is the
Analysis ToolPak, maybe it is something else).

You need to make *that* add-in available on the other machine -- in
addition to the AutoChart Manager.

--
Regards,

Tushar Mehta, MS MVP -- Excel
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
 
Back
Top