LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
mr_teacher
 
Posts: n/a
Default Links to other data sources


Hi,

I have an excel workbook that gives the message attached with it -
basically saying that the workbook contains links to other sources.

I have written the whole spreadsheet myself and know that there should
not be any links to other sources - but equally I have done a fair bit
of cutting, copying and pasting between sheets to come up with the
final template so I imagine that some links could have become
established in tis way.

Is there anyway to see what/where the linked cells are and what the
formula is? Is there a way to look through these similar to the sort of
thing you get with 'find and replace'? What's the easiest way to get rid
of these links and have it just related to the single spreadsheet?

Thanks for any help and advice you can give me

Carl


--
mr_teacher
------------------------------------------------------------------------
mr_teacher's Profile: http://www.excelforum.com/member.php...o&userid=34352
View this thread: http://www.excelforum.com/showthread...hreadid=542460

 
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
Workbook contains links to other data sources?? sbrimley Excel Worksheet Functions 1 March 3rd 06 01:43 AM
Matching and aranging data form two sources nhoh0it Excel Worksheet Functions 1 December 14th 05 07:28 PM
Excel Macro to Copy & Paste [email protected] Excel Worksheet Functions 0 December 1st 05 01:56 PM
Data from Excel 2000 Worksheet with external links is not displayed when opened in Excel 2003 Rich Rodberg Links and Linking in Excel 1 October 21st 05 07:53 AM
Combining two data sources in a Pivot table. Erasmus Bowen Excel Discussion (Misc queries) 0 August 19th 05 09:16 AM


All times are GMT +1. The time now is 05:36 AM.

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"