ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Link error/Warning using macro in files converted to Excel 2007 (. (https://www.excelbanter.com/excel-programming/441890-link-error-warning-using-macro-files-converted-excel-2007-a.html)

John Mulford

Link error/Warning using macro in files converted to Excel 2007 (.
 
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


All times are GMT +1. The time now is 01:02 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com