J
John Mulford
Problem: Receiving the following message during macro run "This workbook
contains one or more links that can not be updated" with the continue or
edit buttons.
This only occurs for some files, which have no distinguishing
characteristic differences to the non warning message files
Background:
Excel files converted, thru manual converter (open file, check
compatibility, and convert) from 2003 to 2007
Macros only conversion was find and replace .xls with .xlsb
Normal manual refresh of links works fine
All files have exactly the same settings
1. Read Only Recommended (Save-as General Options)
2. Update Links - automatic update disabled, desired normal state
is to prompt users (Data,
links, propmt user)
3. Excel options, advanced
When calculating
Update Links [note have levered this with no effect]
Save external link values
General
Ask to update automatic links
Workbooks.Open Filename:= _
CurDir & "\Assumptions - At Risk Marketing Sizing Tool.xlsb" _
Original - ", UpdateLinks:=3, ReadOnly:=False,
IgnoreReadOnlyRecommended:=True"
CHANGED WITH NO EFFECT ", UpdateLinks:=xlUpdateLinksAlways"
I can not seem to find the cause and would appreciate advice.
4 main possibilities come to mind:
1 missing a setting change
2 corruption/incomplete 2003 conversion
3 VB Change
4 2007 installation network security
contains one or more links that can not be updated" with the continue or
edit buttons.
This only occurs for some files, which have no distinguishing
characteristic differences to the non warning message files
Background:
Excel files converted, thru manual converter (open file, check
compatibility, and convert) from 2003 to 2007
Macros only conversion was find and replace .xls with .xlsb
Normal manual refresh of links works fine
All files have exactly the same settings
1. Read Only Recommended (Save-as General Options)
2. Update Links - automatic update disabled, desired normal state
is to prompt users (Data,
links, propmt user)
3. Excel options, advanced
When calculating
Update Links [note have levered this with no effect]
Save external link values
General
Ask to update automatic links
Workbooks.Open Filename:= _
CurDir & "\Assumptions - At Risk Marketing Sizing Tool.xlsb" _
Original - ", UpdateLinks:=3, ReadOnly:=False,
IgnoreReadOnlyRecommended:=True"
CHANGED WITH NO EFFECT ", UpdateLinks:=xlUpdateLinksAlways"
I can not seem to find the cause and would appreciate advice.
4 main possibilities come to mind:
1 missing a setting change
2 corruption/incomplete 2003 conversion
3 VB Change
4 2007 installation network security