Important context: my limited VBA skills have grown quite rusty over the past few years.
I have inhereted a spreadsheet (the main spreadsheet) that opens a number of other workbooks and copies and pastes the data found there into itself. These spreadsheets (the data spreadsheets) are updated every week. So far so simple.
Until relatively recently we believed that it just took a very long time to execute, until I stepped through the code manually and found that when the data spreadsheets open they calculate and this can take a very long time. The entire update used to take hours! (I'm not sure why - there's nothing beyond a csv full of cells - but that isn't a question for now). Stepping through the code manually allows you to short circuit the calculations and complete the process in a couple of minutes.
Obviously this is still a workaround and I'd rather do this at the click of a button.
Is there any way to set a sheet being opened with Workbook.Open to manual? Is there any other way to acheive the same?
I've googled this question extensively and I couldn't find anything (beyond the terms being completely smothered by people asking how to generally open a sheet with Manual calculations)
Thanks
I have inhereted a spreadsheet (the main spreadsheet) that opens a number of other workbooks and copies and pastes the data found there into itself. These spreadsheets (the data spreadsheets) are updated every week. So far so simple.
Until relatively recently we believed that it just took a very long time to execute, until I stepped through the code manually and found that when the data spreadsheets open they calculate and this can take a very long time. The entire update used to take hours! (I'm not sure why - there's nothing beyond a csv full of cells - but that isn't a question for now). Stepping through the code manually allows you to short circuit the calculations and complete the process in a couple of minutes.
Obviously this is still a workaround and I'd rather do this at the click of a button.
Is there any way to set a sheet being opened with Workbook.Open to manual? Is there any other way to acheive the same?
I've googled this question extensively and I couldn't find anything (beyond the terms being completely smothered by people asking how to generally open a sheet with Manual calculations)
Thanks