Link error/Warning using macro in files converted to Excel 2007 (.

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top