Hi
We have a workbook that cycles through retail store P&Ls and saves down as a PDF. The file is large and the calculations are complex, so the total workbook calculation time is about 2 minutes.
I can't seem to stop it recalculating the whole workbook for each save - have tried the Application.CalculateBeforeSave = False at the start of the macro but this only seems to work when I'm saving as an excel file.
Is there a way to disable saving the same way for the Save As when it is a PDF? Or is there an add in people have used successfully to achieve the same?
There are other options, e.g. save each P&L as a pasted values worksheet then cycle through those and convert to PDFs but looking for a quick win.
Any thoughts/assistance? Have done a lot of searching and the absence of an answer suggests there might not be one...
Cheers
Steve
Bookmarks