Disable auto calculating on open for specific file

Hi!

I have a file that as to do a lot of index/match calculations. It is to display machine status over the day and it has a row for every minute of the day, then I run a macro to merge all minutes of the same status to look like a graph/timeline/heatmap kind of thing. It's a form, I have the original file with the database empty, I copy that file, open, paste the data, run the macro and print. So I always use a fresh file.

The problem is that it takes like 30 sec / 45 sec to recalculate everything. When I open the file it takes 30 seconds to calculate an empty database, when I paste the data it takes another 30 seconds. The question here is, how can I eliminate the first calculation when opening the file?

I don't want to use the manual/auto calculate option as that defeats the purpose of fewer clicks, I just want to disable auto-calculate on open (on this specific file), but enable it for everything else. I'm fine with a VBA solution (as the file already as VBA in it).

Thank you all and I hope I was clear, I'm from Portugal soo put my thoughts into another language isn't easy!

Thank you. I was thinking, if manual calculations is an option for each file, I can save that file with manual calculation and then have a macro to just activate it! Thank you for your help

Monday I will post a reply with the solution I applied if there is no new ideas.