Excel Chart Problems

**101RRS** · 2nd July 2010, 10:04 AM

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** · 2nd July 2010, 10:48 AM

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** · 2nd July 2010, 12:18 PM

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** · 2nd July 2010, 03:34 PM

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** · 2nd July 2010, 03:46 PM

Originally Posted by nice1guv

I would go a rouge Macro as well.

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

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

)

**p38arover** · 2nd July 2010, 07:32 PM

Originally Posted by vnx205

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

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

)

Beat me to it!

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

**101RRS** · 2nd July 2010, 07:55 PM

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

Thread: Excel Chart Problems

Thread Tools

Excel Chart Problems

Bookmarks

Bookmarks

Posting Permissions