Excel Chart Problems

[101RRS]

I use Office XP and have a number of excel spreadsheets that I use - none have charts attached.

Often when I open the spreadsheets it goes troppo automatically creating charts from the data (non stop) and creating new books. If I do not close the spreadsheet it will keep on replicating charts until the computer runs out of memory. A couple of thousand.

Now this happens automatically with no input from me and there are no charts that it is copying - it is creating them from scratch. The only way to stop this is to restart the computer and all is OK for a couple of hours then it starts all over again.

I have un-installed and reinstalled Office XP a number of times with change.

Any ideas?

Garry

[windsock]

The only thing I can think of is a macro or macros running amok. Either your own macros or a viral form of them you have inadvertantly uploaded from somewhere.

Go to either C:\\Documents and settings\username\application data\microsoft

or

C:\\Program files\microsoft office 10

and look for XLStart and figure out if any macros are automaticvally opened on start.

Alternatively, I hold SHIFT down when starting Excel to turn off any auto macros.

Hope this helps... macros are great when they do as they're told, just depends on who told them to do what...

EDIT: Try using the ESC key to stop it once it starts.

[nice1guv]

Excel doesn't normally create graphs on its own, so I would go a rouge Macro as well.

Assuming Excel 2003, try this:
Open Excel with a new file
Click on Tools, Macro, Security
Your security level might be low, if so change to medium.
Close and re-open Excel
Load the troublesome file
If it is a Macro causing it, it will ask you to enable Macros, click disable.

Fingers crossed.

[Blknight.aus]

there might be an old macro from another application thats lurking in your templates.

uninstalling office does not always get rid of your templates and documents directory. If youve accidentally saved a macro into one of the default user templates and you have a call to its name from your spread sheet it can be activated that way.

It might also be as simple as someones saved a call to a macro in your current spreadsheet and its calling a macro that you have setup under the same name that does something different to what the spreadsheet expects it to do.

[vnx205]

I would go a rouge Macro as well.



Those pink macros can be a problem, but I suspect that rogue macros are worse. :p:p:p:p:p

(Someone had to fill in for Ron as he is probably too busy now that he has retired. :D)

[p38arover]

Those pink macros can be a problem, but I suspect that rogue macros are worse. :p:p:p:p:p

(Someone had to fill in for Ron as he is probably too busy now that he has retired. :D)

Beat me to it!

I've been in hospital today (nothing serious - now).

[101RRS]

Thanks for the tips - will try an sort those pink macros tomorrow after I get back from hopefully firing up a friends series 1 after it has been re-assembled.

Garry