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