Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

i've got the problem in one excel file, that if i scroll thorugh my sheet, that some values still stay on the screen in cells where they don't belong to. you can see it here: The shown cells are actually empty. I can "refresh" the view by minimizing excel to the taskbar and maximize it again.

The "ghost" values are very annoing. they are also displayed, if in there are other values in the new cells.

have anyone an idea why these values ghosting over my whole sheet?

some specs about my file:
- i've got 12 datasheets
- every sheet is using some sum()-functions
- some sum()-functions are using other sheets as source for the data
- col A-G are fixed while scrolling

share|improve this question
Do you have any panes frozen? Go to view - freeze panes - unfreeze panes if you do – Raystafarian Aug 1 '13 at 15:07
i've mentioned this in the last line of my code... but the values are ghost values and not a result of a freezed pane – Michael Walter Aug 1 '13 at 15:13

You must log in to answer this question.

Browse other questions tagged .