External Links not updating for closed files

A

Antonw

New Member
Joined
Feb 17, 2010
Messages
42
Dear All,

I have got one excel (Destination file) file in which I have used SUMIFS function linked with another excel file (Source file). When I open the destination file and update links, instead of showing the amounts, it shows #VALUES . It will properly update only if I open the source file. Opening the source file always is difficult and I want to get this done without opening the source.

Can someone please help me sort out this issue?

Thanks in advance

AW
 

Excel Facts

Does the VLOOKUP table have to be sorted?
No! when you are using an exact match, the VLOOKUP table can be in any order. Best-selling items at the top is actually the best.
You must log in or register to reply here.

Similar threads

C
  • Question
VBA: Open and close all source files to refresh Master Workbook data
Replies
1
Views
460
t0ny84
T
L
  • Question
Getting Error : UNABLE TO REFRESH We couldn't get updated values from a linked workbook
Replies
2
Views
1K
luckyros
L
M
  • Question
Share excel file on Sharepoint using VBA
Replies
1
Views
118
mariyarashkova
M
L
  • Question
Macro Does Not Close Excel Workbook
2
Replies
14
Views
150
Jeffrey Mahoney
Jeffrey Mahoney
KlausW
  • Solved
copy data from several closed workbooks to one workbook.
Replies
5
Views
698
KlausW
KlausW

Forum statistics

Threads
1,214,982
Messages
6,122,580
Members
449,089
Latest member
Motoracer88

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