Forum Discussion
pq10182
Mar 01, 2022Copper Contributor
Special Paste (Values) without links.
Greetings, I have two workbooks and three sheets. Workbook1 has SheetA and SheetB, and is created daily. Workbook2 has SheetC and is done for the month. Data is input to SheetA and using form...
Mar 01, 2022
Hi pq10182
You can control the links to the document from the Data menu --> from Queries and connection group click on Edit Links --> from the window you can choose:
1- to break the links by click on break Links or
2- Enable/Disable the notification and the update whenever you open the workbook
By click on Startup Prompt --> choose "Don't display the alert and don't update automatic links" --> OK