Forum Discussion

Copper Contributor

Mar 05, 2021

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 ...

excel

Excel for web

Formulas and Functions

Riny_van_Eekelen

Platinum Contributor

Mar 07, 2021

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.

allison790
Copper Contributor
Mar 09, 2021
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.
- Riny_van_Eekelen
  Platinum Contributor
  Mar 09, 2021
  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.
  - allison790
    Copper Contributor
    Mar 10, 2021
    No worries! I appreciate the support!