Simple formula within separate worksheets sometimes does not connect

Occasional Visitor

Anyone know why sometimes a simple lookup formula, example vlookup or indexmatch or xlookup, sometimes just doesn't connect from one workbook to another? Most of the time I have no issues, but sometimes the connection doesn't work as if my two files don't recognize each other. If I close down and start over, usually fixes. Or, if I really don't want to close the files I sometimes insert a sheet, and copy the data I need to the new sheet in the same workbook then do the lookups I need. But, wondering if there is something I am doing when I open files that causes the issue? Using Microsoft® Excel® for Microsoft 365 MSO (Version 2109 Build 16.0.14430.20292) 64-bit

0 Replies