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

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" wrote in message
...
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.

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

"Peter T" <peter_t@discussions wrote in message
...
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" wrote in message
...
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