Forum Discussion
Excel Ref Error online but not on desktop when linking to another table
Hi, So I have 2 seperate spreadsheets and I am linking Table1 from Spreadsheet1 onto Spreadsheet 2. When I do this with Excel desktop it is able to import the data without any issues. The new ta...
I might be crazy but I have 2 sets of linked workbooks. One works online, the other doesn't. It's the same data in both sets.
- the linked workbooks that work online without ref errors don't have tables / structured references & I didn't use power query to clean up the data.
- The linked workbooks with REF errors do. The links 'seem' valid. Same links as the working version, but Ref errors all over the place.