Forum Discussion
Formulas in two separate workbooks are not talking to each other
Hello team,
I have two Excel worksheets. The first workbook has cells that equal cells in a separate workbook.
When I open the worksheet where I am looking to see X answer in the cell fed from the other sheet, I see a yellow flag at the top of my workbook that says "external links have been disabled."
Does anyone know how to resolve this issue and make the workbooks "talk" to each other again? I did a manual update where I selected what each cell should equal. I'm hoping not to have to do this again.
Thanks!
Allison
4 Replies
allison790 In Excel for the Web, you mean like this?
If so, click "Enable Content". Then, on the Data ribbon, Workbook Links.
A menu opens on the right-hand side. Her you can refresh the links.
Riny_van_Eekelen thank you for response!
When I open the book, the below is what I see.
Looks like I don't have the option to enable content. I'm not sure how to triage beyond this...
I was able to "enable content" in the desktop view. However, when I checked my connections, it seemed like the data wasn't connecting to the other files.
allison790 Looks like you file might use Power Query. I opened some of my own workbooks that contain external PQ connections, but did not get the message you see. Not using Excel for the web usually. Sorry that I can not help you any further.
