Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 15
Default Issues with linking to exported source files

We recently loaded excel 2007 onto my PC at work, but kept excel 03 on it as
the default program since the rest of the company still uses excel 03.

I noticed that now my links do not work. Most of my excel reporting is done
as a shell summary workbook that links to multiple source files that have
been exported from our database interface. (These can be exported as .xls or
..xl5)

Before loading in 07, all of my source files were exported as .xls and
worked fine. Now, even though I've totally removed excel 07 from my pc and
unistalled/ reinstalled 03, the links will not update.

If I keep my source file as .xls, when I click update, the program becomes
non- responsive. I can open the source file and it will update, but don't
want to have to do that every single time.

If I open the source file and jusk click save, then close it, then my
automatic update of links does work when I open my shell file and click
update. (But again, don't want to have to do that every single time)

If I switch my source files to be exported as .xl5, I get the error message
"Workbook has no bound sheets" when I click update.

Please help...thank you in advance!

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
Vlookup issues when source data is in another workbook? Kathy L.[_2_] Excel Discussion (Misc queries) 5 February 26th 09 02:56 PM
Linking issues lost then found Excel Discussion (Misc queries) 3 January 12th 09 10:50 AM
Linking Issues Kathy New Users to Excel 3 September 28th 08 04:43 PM
Data Source Trust Issues NervousFred Excel Discussion (Misc queries) 2 July 25th 08 03:40 PM
Linking Issues terri Excel Discussion (Misc queries) 0 June 13th 07 04:25 PM


All times are GMT +1. The time now is 07:04 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"