Remove ODBC links to Sage SQL Server

[krissz]

I have a large spreadsheet (~100 tabs) that gets data from an SQL server using SQL queries. I am about to run a Year-End on Sage (for the first time) and am concerned that this will screw-up the data in the spreadsheet.
I know that I can open each Tab in turn & unlink, or Copy/Paste values-only, but is there a simpler way to unling the whole spreadsheet.
Or will the Year-end not affect the data ?

 

[jsotola]

make copy of the workbook

then run year-end on the copy

if there is a problem, you can investigate