•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
How do I find and fix a “Cannot find #REF!#REF!” error?
Every time I open this sheet in excel it gives a pop up saying “Cannot find #REF!#REF!, which has been assigned to run each time Book1 xIsm is opened. Continuing could cause errors. Cancel opening Book1 xIsm?”
I have a MASSIVE sheet with 10s of thousands of lines on each tab, and I’m really struggling to find what’s causing this error.
I don’t have any macros, I don’t have any workbook links, and I tried using the “error checking” button on every tab but it didn’t find anything. I don’t have any hidden tabs. I don’t have anything in power query.
What could be causing the problem, and how do I find it and fix it? I get this pop up every time I open the sheet and it’s so annoying.
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#real-time data collaboration
#real-time collaboration
#Excel compatibility
#Excel alternatives for data analysis
#Excel alternatives
#rows.com
#financial modeling with spreadsheets
##REF!#REF!
#Excel
#error
#workbook links
#error checking
#macros
#hidden tabs
#power query
#pop up
#massive sheet
#lines
#fix
#causing problem