This workbook contains one or more links can not be updated!

M

malehot888

Board Regular
Joined
Sep 16, 2005
Messages
52
Hi Guys & Gals,

I have a really isolated case here and I'm not sure if anybody has answer so it is goes.

I have a master workbook that has vlookup links to 12 other files (each representing a period). I wrapped each vlookup with a iserror statement. Now since we're only in Period 2 of the year, i haven't created files for period 3 - 12 so i get the annoying "This workbook contains one or more links can not be updated. To change the source...click edit links. To open workbook as is, Click Continue."

I want the excel file to automatically hit continue without the user seeing that message. Is there a way to do that in VBA? Or am i the king of wishful thinking?

Thanks in advance.
 
Sort by date Sort by votes
How about you wrap another IF statement around your formula?

Keep the current month # stored in A1. Then for each monthly column use this:

Jan
=If(A1 >= 1, "link to your file",0)

Feb
=If(A1 >= 2, "link to your file",0)

I think doing it this way, Excel will not try to process the link until you change the month #.
 
Upvote 0
That was a good suggestion and I thought it would've of worked, but it doesn't work. When you open the workbook, excel tries to update all links regardless of there is an if statement telling it not to. Thanks for you reply though.
 
Upvote 0
You must log in or register to reply here.

Similar threads

J
  • Question Question
Prevent Automatic Link Updating/Changing
Replies
0
Views
134
jbennett01
J
T
  • Question Question
How can I reduce file size of workbook referencing sheets in another workbook?
Replies
4
Views
360
bobsan42
bobsan42
C
  • Question Question
Create a link to another workbook via form control
Replies
1
Views
152
Micron
M
J
  • Question Question
VBA Script to Update Files in a folder, updating Links
Replies
1
Views
661
Micron
M
A
  • Question Question
Excel Online Sharepoint - Workbook Links Updating with New Rows Added
Replies
0
Views
437
ah_mktanlys_01
A

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