Forum Discussion
External data referencing returns #REF! error
I am working on some spreadsheets with my company's expenses and financial information. One workbook, 2022 Expenses PivotTable, has information on all expenses, the income, and salaries. In a differe...
attached an image of the #REF! error from Excel online since my Excel app is too slow right now from a company wide SharePoint sync;
If too slow,I guess you need another B/S architecture to share data.
The reason it was slow was because over 20K files had to sync due to folder restructuring lol