View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
NickHK NickHK is offline
external usenet poster
 
Posts: 4,391
Default Camera tool is slowing macro

I would imagine it is because you now have linked pictures that have to
continually update when the data is changed.
The updating is a background operation, but obviously takes time/CPU cycle
to execute, giving less to your macros.

NickHK

"Yokie Cahyadi" <Yokie wrote in message
...
Is this a known issue or bug? I have a file that contains simple macros to
automate repetitive tasks. The macro works fine and very fast until this
month. I added one tab to show few charts which were created using the

camera
tool. Strange but true, the same macro now runs very slow and takes a
considerable time to complete. I'm very sure that the problem is not the

way
I wrote the macros (if I deleted the new tab, my macro would run very fast

as
usual). Note that my macros do not refer to the charts and vice versa. I
believe if you have a worksheet/workbook with charts created using the

camera
tool, they will slow your macros.

Please let me know how I can use the camera tool and at the same time, I

can
run my macro smoothly and fast.

Thanks in advance.