Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2
Default 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
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2007 External Link error munish Excel Discussion (Misc queries) 0 January 14th 09 09:02 AM
Link Excel 2007 file to 2003 files Chrisp Excel Discussion (Misc queries) 3 July 17th 08 12:08 PM
EXCEL 2007 EXTERNAL LINK ERROR-NEED HELP munish Excel Discussion (Misc queries) 0 July 10th 08 10:05 AM
Excel 2003 converted to 2007 copying worksheet error MAC Excel Discussion (Misc queries) 0 September 6th 07 08:16 PM
Excel filees being converted to zip files SteveInstructor New Users to Excel 2 July 15th 07 11:39 PM


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

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"