Hi,
I wonder if someone could please help me - In my spreadsheet there are approx 100 worksheets, which has a data linked from different file. Everytime I open it, some data is updated and some is blank and I have to manually press F2 and Enter and then it updates it. My setting is all correct i.e. Automatic Calculation etc.
Please can someone guide me whether there is a way to update all cells correctly when opening the workbook either through VBA or any other setting.
Thank you
I wonder if someone could please help me - In my spreadsheet there are approx 100 worksheets, which has a data linked from different file. Everytime I open it, some data is updated and some is blank and I have to manually press F2 and Enter and then it updates it. My setting is all correct i.e. Automatic Calculation etc.
Please can someone guide me whether there is a way to update all cells correctly when opening the workbook either through VBA or any other setting.
Thank you