LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 15
Default Links using XLODBC.XLA not working after upgrade to 2003

I wrote a workbook that uses SQL.REQUEST to pull information from an access
database. After upgrading from Office 2000 to Office 2003, the workbook no
longer works. I get the following error message:

"This workbook contains one or more links that cannot be updated."

When I use the "Edit Links" button to investigate, it shows that the
XLODBC.XLA add-in is the problem. It's status shows: "Error: Source not
found". I've searched my system for this file and it's no longer present,
as far as I can tell. The location where it used to reside in O2K
(C:\Program Files\Microsoft Office\Office\Library\Msquery\XLODBC.XLA) no
longer exists; the folder structure ends after "C:\Program Files\Microsoft
Office\Office".

I'm sure Excel 2003 is still capable of providing this functionality, but
I'm not sure where to look for it. Any help appreciated.

Thanks in advance.

Bryan


 
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
What substitutes XLODBC.xla add-in in Excel 2003 Ladislav Excel Discussion (Misc queries) 0 April 7th 06 03:11 PM
=networkdays formula was working, but not in upgrade to 2003 bakercenter Excel Worksheet Functions 2 March 27th 06 11:04 PM
Update Automatic Links Not Working in 2003 cydkil Excel Discussion (Misc queries) 2 February 15th 05 03:35 PM
upgrade to excel 2003 update broken links error tigger Links and Linking in Excel 0 December 1st 04 06:39 PM
Need xlodbc.xla in Excel 2003 troubled Excel Programming 1 September 24th 04 07:44 AM


All times are GMT +1. The time now is 10:06 PM.

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

About Us

"It's about Microsoft Excel"