I had the same issue when I enabled Analysis ToolPack and its related built-ins. These built-ins contain macros too, probably this was the root cause.
After disabling them, the issue disappeared.
Quote:
Originally Posted by teabag
Thanks for this, JLGWhiz. I do have autosave checked and I will stop worrying
about it. Since getting help a few days ago, I have been closing Excel
instead of just the file and this clears the "clones" away - which gels with
your autosave tip, too, I guess.
Sorry about the delay, by the way: the email announcing your response got
caught in our spam filter so I didn't know to look for it till I checked spam
today.
Grateful teabag.
........................................
"JLGWhiz" wrote:
If you have autosave checked on your ToolsOptionsSave tab then you could be
getting a different version number assigned as the file auto saves if changes
have been made in the mean time. I have noticed the version suffix on my
files on occasion but they usually go away when I manually save and close the
file. When you open the file, the basic file should be the one to open, not
the version suffixed files, so you really don't have to worry about it.
"teabag" wrote:
Nick, Thanks for the interesting link - always a comfort to read about
fellow-sufferers.
I think I give up - thanks for your time,
Best regards,
teabag
"teabag" wrote:
Er, no, Nick - should I?
Regards,
teabag
"NickHK" wrote:
Do you have Google Desktop installed ?
http://groups.google.co.uk/group/mic...f43483 83ab93
NickHK
"teabag" ...
Please could someone suggest why I get multiple versions of my VBA project
in
Project Explorer? It's irritating because changes I make to the code in
one
"clone" don't have any effect if the worksheet seems to be paying
attention
to another one.
It seems to be OK if I consistently enter changes only into the uppermost
version of the project (provided I remember to avoid the others) - but why
are the duplicates there anyway?
Sometimes it goes back to one version on reopening the workbook; currently
I
have three identical-looking versions in Project Explorer and I'm worried
that some changes will get lost if I accidentally enter in the wrong
clone...
|