Forum Discussion
data tables & index/match function
I reposted my question as apparently when I thanked someone for putting it into the correct community, interpreted as a response, so unfortunately, I am still in the data table & index/match function quagmire.
As of yesterday, when I create a data table within a Excel 365 file & use that table within an index/match function, when I hit enter, the formula is looking for an external source & never had to do that before. when I ignore, I then get a NA or a #spill! error. Then when I save the file & reopen it, it is trying to update an external link yet there are none anywhere in that file except for the newly created data table.
If someone would be able to get me out of this nightmare, it would be greatly appreciated. I have attached a file.
I selected File > Info.
I saw this near the lower right corner:
I clicked on 'Edit Links to Files'.
I clicked 'Break Link', then clicked Close.
When I saved, closed and reopened the workbook, the message didn't appear.