Hi! First post here - I'm looking for any ideas that might help me solve a troublesome problem.

I have a complex Excel sheet, which runs as a 'dictator' application (See 'Professional Excel Development' by Bullen, Bovey and Green).

The sheet includes lots of VBA, including add-ins, behind the scenes; Reuters Datastream access and four or five other workbooks referenced. There's lots going on!

The problem I'm getting is that when I switch from one worksheet to another on the main GUI, via the Excel worksheet tabs visible at the bottom of the window, a certain amount of the previous worksheet is retained onscreen, apparently overwriting the content of the worksheet to which I've switched.

It looks like some kind of memory issue or something.

If you've ever seen anything like this before, please could you post about it, and any solution you found?

Many thanks,

Alex Berry
Edinburgh, Scotland.