Forum Discussion
lynnewisconsin
Mar 17, 2023Copper Contributor
Creating a reference link FOR TEXT to a cell in another workbook
Hi there! Is it possible to create a reference link for a cell in another workbook? It's for a cell that has text, not numbers/data/formulas. I can use the = sign to create a reference link within th...
lynnewisconsin
Mar 27, 2023Copper Contributor
HansVogelaar Thanks for trying but I'm not trying to link to a formula. It's TEXT. I'm thinking it's not possible. I've tried everything I can think of.
HansVogelaar
Mar 27, 2023MVP
The formula that I posted should work, regardless of whether the cell that the formula refers to contains a formula or not.
- lynnewisconsinMar 27, 2023Copper ContributorIt didn't work. Is it because I'm linking the Excel cell to a Microsoft Teams spreadsheet from an Excel spreadsheet in SharePoint? They're both on my company's network.
- HansVogelaarMar 27, 2023MVP
That might well be, but I have no experience with that setup, sorry.
- lynnewisconsinMar 27, 2023Copper Contributor
I appreciate you trying! 🙂