Forum Discussion
data tables & index/match function
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
16 Replies
This reply is not relevant anymore
See reposted question re: data tables & index/match functionHansVogelaar Hello all! I wasn't aware you (rservice0320) had re-posted the question and to avoid duplicates, I have merged these two threads. Sorry for any confusion!
- except if you break the link, the formula is changed into a value which is what I don't want to happen. I still need the index match formula to work. So, unfortunately, breaking it doesn't solve my issue.
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.
- so, this is still an open issue. I don't know why it auto clicks on best response. Should I repost my question?
- In the drop down menu next to your comment (the ...) you would have selected "best response" by accident.
If you are 100% certain you didn't do that, I can reach out to our tech lead to indicate that in case there's a bug.
If this happens again, you can also remove "best response" through the same menu.
I have removed the "best response" marking from your post.
Hello! You've posted your question in the Tech Community Discussion space, which is intended for discussion around the Tech Community website itself, not product questions. I'm moving your question to the Excel space - please post Excel questions here in the future.
- thank you. I couldn't figure out how to do that. & upload a file.
