PAfE: Refreshing Behaviour Issue
Posted: Fri Mar 19, 2021 10:19 am
Hello,
I am curious if anyone is experiencing the same strange refreshing behavior as I am and if anyone has found a solution to it:
I am currently working on a rather large custom report with some VBA-Code. To make this report work, I have to refresh some cells multiple times while the code is running. For this I am using RefreshSelection as described in the PAfE API documentation.
The strange thing is PAfE is sometimes taking forever to refresh a selection, even if it is small. The time is often comparable to refreshing the whole sheet or book. Also, sometimes just calling RefreshSelection on an empty cell takes forever, which is surprising, since there is no Formula, which could be refreshed.
This behavior, as it stands, is unusable, since just running the affected once takes way too long.
I am looking forward to your responses
I am curious if anyone is experiencing the same strange refreshing behavior as I am and if anyone has found a solution to it:
I am currently working on a rather large custom report with some VBA-Code. To make this report work, I have to refresh some cells multiple times while the code is running. For this I am using RefreshSelection as described in the PAfE API documentation.
The strange thing is PAfE is sometimes taking forever to refresh a selection, even if it is small. The time is often comparable to refreshing the whole sheet or book. Also, sometimes just calling RefreshSelection on an empty cell takes forever, which is surprising, since there is no Formula, which could be refreshed.
This behavior, as it stands, is unusable, since just running the affected once takes way too long.
I am looking forward to your responses