• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

VBA Expert, How to instantly create the report by VBA as my excel file is very slow due to lots of excel formulas?

D

Dennie

New Member
Hi All Experts,

I am currently using excel 2019 and I have the excel file which generate the report too slow due to have lots of long formulas in excel.
My excel contains of 5 sheets. And my "weekly analysis report and summary sheet" report that I wish to have VBA to instantly generate the report. Please note that the details sheet is the raw data which I need to update as daily or weekly. If possible the "detail sheet in column A and O" can be used VBA also, so the report will be not running slow?

Due to my file is 1.6MB which bigger than the requirement, so I would like share to download link as below:
https://we.tl/t-93CX60kXDC

Thank you!
 
Last edited:
First let me be sure I understand the problem: You have an Excel workbook with a lot of data but not a lot of worksheets. You want to generate a report from the data, but the report takes a long time to run. Is that right?

If it's not right, please try again to explain what your problem is.

If I said it right, the next question is this: What method are you using to generate the report? Is it a VBA program, or are you exporting one worksheet to PDF, or what?

(Maybe I could tell if I looked at your worksheet, but I won't click on a strange link from someone I don't know :).)
 
BobBridges said:
First let me be sure I understand the problem: You have an Excel workbook with a lot of data but not a lot of worksheets. You want to generate a report from the data, but the report takes a long time to run. Is that right?

If it's not right, please try again to explain what your problem is.

If I said it right, the next question is this: What method are you using to generate the report? Is it a VBA program, or are you exporting one worksheet to PDF, or what?

(Maybe I could tell if I looked at your worksheet, but I won't click on a strange link from someone I don't know :).)
Click to expand...
Hello @BobBridges

Thank you for response.
My excel file contain of 5 worksheets. one of my worksheet which is weekly analysis contain lots of formula which links to other 4 worksheets. and another worksheet which is summary report that generate the date from the detail sheet. And this Details sheet need to distinct count for transaction. So the sheets needs to be focus are "weekly analysis" and "summary".

And I am not exporting any data from PDF as i have raw data in excel which i just copy and paste to the "Details" sheet, so I will generate the report automatically, but to slow... however, I also delete the formula in "Summary" sheet as it running very slow.

That's why I am seeking for VBA that can instant generate the report.

The link is WeTrasfer and this is not contain any virus as I attached the .xlsb file.

Thank you!
 
Dennie said:
...i have raw data in excel which i just copy and paste to the "Details" sheet, so I will generate the report automatically, but to slow...
Click to expand...
So you paste data to the Details worksheet and then print that sheet? I don't understand how printing a single worksheet can be slow. What method are you using to print that sheet?

Or why is it slow? Is it slow when you paste the data into the sheet, or when you start the print?
 
BobBridges said:
So you paste data to the Details worksheet and then print that sheet? I don't understand how printing a single worksheet can be slow. What method are you using to print that sheet?

Or why is it slow? Is it slow when you paste the data into the sheet, or when you start the print?
Click to expand...
Hello Sir,

No, I don't want to print. My excel already automatically generator the report for weekly analysis. But the lots of long formulas there which cause the excel generate the report so slow. Yes, when I paste the data, then it generates the report very slow.
 
Ok, not printing. But then what form does the report take? Do you have a program writing the report out to a text file? To another Excel workbook? I may have misunderstood when I first read your description; I thought you wanted to write a VBA program to generate the report, hoping it would work faster than it works now. But if you're not printing the report, does that mean you already have a VBA program and you just want ways to make it work faster? How are you generating the report?
 
BobBridges said:
Ok, not printing. But then what form does the report take? Do you have a program writing the report out to a text file? To another Excel workbook? I may have misunderstood when I first read your description; I thought you wanted to write a VBA program to generate the report, hoping it would work faster than it works now. But if you're not printing the report, does that mean you already have a VBA program and you just want ways to make it work faster? How are you generating the report?
Click to expand...
My excel report is using formulas to generate report based on date criteria. For example, If i want to see sale performance for each week, then I just change the date, so I will be automatically update the report for me. However, it's running so slow. That's the reason why I need help if VBA can instantly generate the report instead of using the excel formulas.
 
You're repeating the phrase "generating the report", but you're not answering the question of how. Let me back up: What is a "report" to you? When your Excel worksheet "generates a report", does that mean it creates a file?
 
Dennie

Create a folder with little data like the one you use, and post it. It's better to understand what you want.
 
You must log in or register to reply here.
Back
Top