Trying to replace content in cells linked to another spreadsheet

fgon73

New Member
Joined
Sep 23, 2019
Messages
1
Have an odd problem when using excel in my computer. Everytime I try to update a cell in a spreadsheet that is already connected to another one, I being asked to find the file again and link it for every cell, this means that I need to go one by one selecting the file, rather than doing it automatically. The system is asking me to find the file to link the cell. This has to be done for all of them, thus is time consuming.

Checked in other computers with members of my team and they don’t have this issue. When they want to replace a cell linked to another spreadsheet they can do it ok without a window appearing and asking to link to the other file.

Can you advice?




 

Excel Facts

Best way to learn Power Query?
Read M is for (Data) Monkey book by Ken Puls and Miguel Escobar. It is the complete guide to Power Query.
Are you working in the cloud (sharepoint)? I sometimes have weird issues with file connections. Not yours, at least I am not using hyperlinks like that. Before cloud days things worked fine. Now a lot of things don't.
 
Upvote 0

Forum statistics

Threads
1,213,550
Messages
6,114,265
Members
448,558
Latest member
aivin

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top