Hi all,
i am having a small problem.
I have an excel spreadsheet with VBA which opens another Excel spreadsheet, copies and pastes data from the second spreadsheet to a specific spreadsheet in the first file and closes the second file.
The first workbook has many spreadsheets that have formulas which are linked to the spreadsheet where the data is being pasted.
The problem is that when the second file is opened, Excel wants to update all these links while it is pasting across. I have Calculation on manual and Workbooks.Open UpdateLinks:=0
Is there anyway to just copy the data across without it wanting to update the linked data?
Thanks,
Ryan
i am having a small problem.
I have an excel spreadsheet with VBA which opens another Excel spreadsheet, copies and pastes data from the second spreadsheet to a specific spreadsheet in the first file and closes the second file.
The first workbook has many spreadsheets that have formulas which are linked to the spreadsheet where the data is being pasted.
The problem is that when the second file is opened, Excel wants to update all these links while it is pasting across. I have Calculation on manual and Workbooks.Open UpdateLinks:=0
Is there anyway to just copy the data across without it wanting to update the linked data?
Thanks,
Ryan