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" <(E-Mail Removed)> wrote in message
news:#(E-Mail Removed)...
> 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
news:(E-Mail Removed)...
> 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" <(E-Mail Removed)> wrote in message
> news:#(E-Mail Removed)...
>> 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
>>
>>
>
>