Can you update links without opening the source file?

  • Thread starter Thread starter Guest
  • Start date Start date

Excel Facts

What is the last column in Excel?
Excel columns run from A to Z, AA to AZ, AAA to XFD. The last column is XFD.
Sort by date Sort by votes
In short, yes you can, it just takes longer to do.
Open a file with links, say yes to update and see what I mean, then compare the same process when you have the source file open. Depending on the number of links, it's many many times faster.

Rgds
AJ
 
Upvote 0
You must log in or register to reply here.

Similar threads

S
  • Question Question
Linked file doesn't update
Replies
9
Views
248
Alex Blakenburg
A
A
  • Question Question
Changing row number dynamically in link to another file
Replies
1
Views
193
AlphaFrog
AlphaFrog
S
  • Question Question
ADO to open a "Password protected" XLS or XLSM file
Replies
0
Views
137
skillilea
S
M
  • Question Question
Updating Excel Links during an ACTIVE Powerpoint Presentation
Replies
0
Views
58
mikeb7500
M
W
  • Solved
Formula with Link not working in VBA
Replies
2
Views
232
woodsy74
W

Forum statistics

Threads
1,223,406
Messages
6,171,927
Members
452,434
Latest member
NUC_N_FUTS2

Share this page

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