Thread
:
Camera tool is slowing macro
View Single Post
#
2
Posted to microsoft.public.excel.programming
NickHK
external usenet poster
Posts: 4,391
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.
Reply With Quote
NickHK
View Public Profile
Find all posts by NickHK