excel viewing error

[IkeMike]

Hi there!

I m using since a half a year an excel tool which uses some macros. everything was working fine, till i opened two instances of the same file and run in one file one of the macros.

after i run the macro the screen of the one excel was quite strange. at one excel sheet i saw parts of the other excel workbook from another worksheets.

when i clicked away from the worksheet and back the things left. i thought it was just because the two instances were open. but now always when i run this macro it shows me always the sheet, which was open when i first encountered this strange behaviour. even when the other file is closed!

i will post a link to a screenshot in a minute! i m pretty sure that it is not a problem with the macro, since the macro always run without problems and the macro only updates the screen and does some basic operations.

so it seems to me as excel has something in its cache. is there something like an excel cache? anybody an idea what i could do? dont want to deinstall-reinstall excel just to get rid of it..

would apprechiate any help..

picture link:
[edit] http://mocaso.vs120027.hl-users.com/error2.JPG [/edit]

 

[kab7030]

Mike,

I am having somewhat similar problem. I have different version of same workbook. When, i open any one version, i get phantom images of buttons from one sheet on another sheet and it happens with all of the workbooks, no matter which version i open. I even moved the workbooks to other computer and got the same problem.

However when i create some other workbook with buttons and run it then all seems to work fine.

Hopefully somebody can give a solution. Is there a way to reset excel to it default? or maybe as you say clear the cache or something.