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

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
 
T

Tushar Mehta

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top