We download excel Profit and loss data from Xero. I now have a table in an excel file that is linked and refreshed from xero when opening the file. How do i break this link so that the previous downloaded data just sits in an excel table and is not refreshed by datadear. I want to break the link in only the one tab as we have other linked data in the same workbook that we need to keep links open.
Please can you assist urgently.