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.
 

Excel Facts

What does custom number format of ;;; mean?
Three semi-colons will hide the value in the cell. Although most people use white font instead.
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
VBA Script to Update Files in a folder, updating Links
Replies
1
Views
176
Micron
M
A
  • Question
Excel Online Sharepoint - Workbook Links Updating with New Rows Added
Replies
0
Views
113
ah_mktanlys_01
A
L
  • Question
Getting Error : UNABLE TO REFRESH We couldn't get updated values from a linked workbook
Replies
2
Views
1K
luckyros
L
W
  • Question
Sheet that updates by referencing cells in workbooks located in separate folders on shared drive
Replies
0
Views
164
Woodpusher147
W
A
  • Question
Help Using VBA To Create A Workbook Containing VBA
Replies
2
Views
411
Aldk_1
A

Forum statistics

Threads
1,215,339
Messages
6,124,375
Members
449,155
Latest member
ravioli44

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