Alexey Ivanov

VBA run-time error during refresh of report

Posted on Jul 22, 2020 at 11:09 AM 79 Views

Hello!

I got a VBA error as presented on screenshot everytime i try to refresh report with large amount of data. The same report but on smaller data slices works ok, no vba errors. The error appears on step:

epm.ResfreshActiveSheet

if I try to Debug error and give it another try to process (F5) - it appears again after some time of proccessing.

Any ideas how to make it work with big amount of data?

Thx in advance!

screenshot.png (64.0 kB)

Add a comment

1 Comment

Vadim Kalinin

Jul 22, 2020 at 05:25 PM

First - I will NEVER help if you use "Insert File" instead of correct "Insert Image"
Second - do you really think, that it's possible to help you without vba code posted???
- Like 0
- Share
- Alert Moderator

0 Answers

Sort by:

Votes

Newest

Oldest

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.

Rules of Engagement

Know someone who can answer? Share a link to this question.

Attachments: Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.