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: 3
Default Disconnect a spreadsheet from its datasource

Hi all,

I'm new at this, so I'm appologising in advance if this is a dumb
question. I have a generic report spreadsheet connected to a table in
an access database. The spreadsheet updates through an MS Query on
opening. What I need to do is enable the user to save a version of the
spreadsheet without a link to the database, and at the same time
preserve the link in the generic report. Thanks in advance.

Jenni
 
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
Pivot Tables disconnect Edi151 Excel Discussion (Misc queries) 1 March 5th 09 04:40 PM
Updating A Datasource Rob Excel Discussion (Misc queries) 0 November 3rd 08 06:01 PM
How to disconnect the line for Internet? Eric Excel Discussion (Misc queries) 0 March 7th 08 04:29 AM
to disconnect a destination book from a source book officegirl Excel Discussion (Misc queries) 4 December 10th 07 09:28 PM
Disconnect linked file SLP Excel Discussion (Misc queries) 3 July 5th 07 02:40 PM


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