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...
LilYawneyCan't really tell. Did some tests myself with SUMIFS to a closed file. Didn't cause any problems.
It's a weird problem; I hadn't seen it before and I've referenced closed workbooks thousands of times before. The problem seems to have solved itself (some how).