BIG BLUE partial screen problem?

[Allan P. London, CPA]

Folks,

For some reason, after running some VBA code that writes a lot of data to a
worksheet (about 25,000 lines by 16 columns) and refreshes the related
Piovot Tables and graphs , I get a big blue area across the left third of
the screen on all worksheets. The only thing to do is save my workbook and
close Excel. When I reopen Excel, everything is OK. This does not happen
every time and does not happen very often. It is also happening on my
clients computer on occation. Onbly happens on Excel 2003, never on Excel
2007. Is there a way to avoid this problem?

I can't post the code, it is several hundred lines, but it does include
building then posting arrays to a worksheet and refreshing 6 related Pivot
Tables and charts. I strongly suspect that the charts are the problem
because I placed them on the same sheet as the Pivot Table. Someone told me
that was not a good idea and could crash Excel? But the reports are so
cool!

Thanks,

Allan P. London, CPA

 

[Peter T]

Hi Allan,

A wild guess, try formatting your charts to "Don't move or size with cells"

ActiveSheet.ChartObjects.Placement = xlFreeFloating

Regards,
Peter T

 

[Allan P. London, CPA]

Peter T.

Great Idea! I changed the properties on all 15 charts to dont move or size
with cells and the problem has not returned for the last two days - so I
think that fixed it.

Thanks.

APL