excel viewing error

IkeMike

New Member
Joined
Jun 19, 2009
Messages
40
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]
 
Last edited:

Some videos you may like

Excel Facts

Highlight Duplicates
Home, Conditional Formatting, Highlight Cells, Duplicate records, OK to add pink formatting to any duplicates in selected range.

kab7030

New Member
Joined
Dec 2, 2009
Messages
14
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.
 

Watch MrExcel Video

Forum statistics

Threads
1,123,057
Messages
5,599,550
Members
414,316
Latest member
ExcelLee

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top