Free Microsoft Excel 2013 Quick Reference

Unable to break links

I am using Excel 2003 SP2. I have a workbook that contains links to 7
different spreadsheets. I want to send the workbook to others, but want to
break the links so that they see the actual values I am sending, not the
linked value in case that would change in the meantime. I have done this
before - I go to Edit, Links, and then highlight the links and select "Break
Link". However, when I do this only one of my sources is removed - the other
6 are still listed, and the formulas linking to the workbooks still exist.
All of the workbooks sit in the same folder on the server. What am I doing
wrong?


Hi,

Last week I copied a worksheet from one spreadsheet into another, and have since been working from the new one. When I open the file I get a message box asking if I want to Update links from the other workbook. But I've deleted all named ranges, formulae, shapes, everything that could possibly link to the other workbook. I've also (in my frustration) completely deleted the sheet that was originally copied and re-made it from scratch. But it STILL comes up with this update box. In Excel's Help it says to go to Edit/Links and press Break Link, which I have tried but it doesn't do a thing. The link is still sitting there in the display box in the Links window - it says that the Type is Worksheet, I don't know if this makes any difference that it's not a formula or anything?

Also, in complete desperation when it wasn't deleting the link, I changed the source to a random file, so it now comes up with an error in updating (which it obviously would) however this doesn't have any effect on my file because as far as I can tell it no longer has links to the other file!

I'm tempted to just go to the option that says don't show the Update prompt on opening (the file is to be handed in as coursework on Wednesday) but this doesn't solve the problem, only bypasses it!

Each time I made a major change (e.g. recreating the copied worksheet, changing the source) I saved the file under a different name, so I have all old copies just incase I've completely messed it up!

Any ideas what this link is up to?

I am using Excel 2003 SP2. I have a workbook that contains links to 7
different spreadsheets. I want to send the workbook to others, but want to
break the links so that they see the actual values I am sending, not the
linked value in case that would change in the meantime. I have done this
before - I go to Edit, Links, and then highlight the links and select "Break
Link". However, when I do this only one of my sources is removed - the other
6 are still listed, and the formulas linking to the workbooks still exist.
All of the workbooks sit in the same folder on the server. What am I doing
wrong?

Hi,

I'm hoping you can help me.

I've created a Word template (let's call it Conf Template) which has a whole bunch of links to an Excel document. The project involves opening the Excel document, making some changes to the linked cells, opening a new document of the Conf Template (let's call it JP Trip), updating the links with the new values, breaking the links and then saving it. The problem I'm having is when I try and open the new document, JP Trip, it still asks whether I want to update links. However when I go to Edit->Links... it's greyed out... Any idea on why this might be? I'm looking to remove all links in this document so that it becomes just a normal Word document. I've attached a copy of the Word document which should have no links but asks whether you want to update links when you open it.

I'm using Word 2003.

Hopefully I've explained the problem adequately if not I'd be happy to clarify.

Thanks for taking the time to read my post (and hopefully help!)

Emmeline

I use Excel to create working papers and link between worksheets to create
reports. When I send these reports to executive management I don't want to
included all my working papers. Right now you can only break links to data
in another file. I have to move the report worksheet to a blank workbook and
then I can break the links in the report so that all my data remains and I
can email the file to management. Very frustrating, it would be very useful
to be able to break links between worksheets in the same file.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...et.f unctions

I seem to be experiencing an issue when i try to create a hyperlink. I get an error that says: "Unable to open "link". No program is registered to open this file". Does anyone know how to resolve this issue?

thanks in advance

Josh

I use Excel to create working papers and link between worksheets to create
reports. When I send these reports to executive management I don't want to
included all my working papers. Right now you can only break links to data
in another file. I have to move the report worksheet to a blank workbook and
then I can break the links in the report so that all my data remains and I
can email the file to management. Very frustrating, it would be very useful
to be able to break links between worksheets in the same file.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...heet.functions

In Excel 2003, under Edit, you could click on Links and go to Break Links to get rid of links to other workbooks. How can I do this in Excel 2007?

In 2002 XP there is a vba method to break links. I copy the sheet to another book and break the link before emailing the sheet. I need a vba routine to do the same in 97.
Living in hope.
Terry

Hello:

I have a simple grid of 24 months of data. Each of those months' data is linked to one particular spreadsheet. Is it possible to break the links only for the first 12 months and leave the latter 12 months linked? A copy/paste/special value option would be very time consuming.

Thanks!

Hi there!

Ive created a linked spreadsheet in 2003 and am unable to open in 97. The
error msg i get is "unable to open - insufficient memory". Any clues how i
can get around this little dilema???

Thanks in advance!

I have a spreadheet I want to use going forward, but there are three macros
set to run upon opening. I have tried to break the links and delete the
macros but cannot as they are from an unidentified source. Does anyone know
how to remove these so I no longer get a prompt upon opening my spreadsheet?
--
Regards,
Nate

Hi. I'm looking for a macro that will automatically break all links to other sheets and convert the data to values before emailing. The closest help I can find is here: http://support.microsoft.com/kb/192895/en-us but I don't want to give the option to decline.

I've already got a macro written the convert the sheet to values and then email it- I just need to insert something between that breaks the links to other sheets. This is what I'm assuming since when I open the emailed file it still asks whether or not I want to update links (and then says that those links are invalid).

Please help.

Hi there!

Ive created a linked spreadsheet in 2003 and am unable to open in 97. The
error msg i get is "unable to open - insufficient memory". Any clues how i
can get around this little dilema???

Thanks in advance!

Hi, Anyone knows how to break links in an excell sheets with vba code?

Thanks Thomas100

Hi All
Newbie Here
I have a spreadsheet with 2 linked fields.
I know I can break link with excel but the problem is that I need to use the links next time I open the sheet.
I wanted to know if I could Record a macro to break links and then save the sheet as a new name. I have Tried and the record does not seem to work.
that way I can email the new sheet and leave the old sheet links alone.
I have no real exp. with VB.
Can anyone help.

I am unble to break links in Excel 2000 but it works in Excel 2003. Is there
any way to break the links in Excel 2000??

Hi,

I was wondering if there is a way to break links in Excel such that it
does not retain the data that is currently in that cell. What I am
trying to do is set up a summary sheet that links multiple different
workbooks (around 20 or so), however I want the associated linked data
to become "NA" or someother irrelevant value if I delete 1 of the
workbooks. In otherwords instead of breaking the link and keeping the
old value, I want to be able to break the link and lose all data
associated with it.

Any suggestions?

I am analyzing a query with excel. In excel, I have created a template that
is linked to the query. I want to email that template on to others, but
they are getting messages, unable to find source - unable to update link,
etc. They can ignore errors and receive the worksheet without errors.

Is there a way to send info from access to email users while retaining the
format and having some fields protected? Then, they can enter info into
unprotected fields and email back to me.

Any suggestions?

Thanks in advance,
JR

Each month I have to break the links in about 40 workbooks, each with 10-15
worksheets in each.

Currently, I open each workbook, group all the tabs and then Copy/Paste
special values to break links.

Is there an easier way to this - sort of like a batch???

Thanks,
Tom

I am trying to "Break Links" within a spreadsheet and I keep getting an error saying that I need to unprotect my sheet. The problem is that my sheet is not protected right now. Any ideas out there to solve my problem?

Thank you.

Unable to save external link values

CAUSE
This problem occurs when you save a workbook that contains a link to a range of cells in a different workbook, and the range is more than 16,000 cells. This problem occurs because Excel cannot save a workbook that contains a link to an external range of more than 16,000 cells.

Is there a way to get around this other than breaking the external range into smaller pieces?

I created a budget vs actual model in Excel with several sheets of data,
vlookups, and indexing formulas on many of the sheets. Now I want to break
the data sheets into another workbook to reduce the file size and eliminate
duplication of data, among other problems. (We are planning about 25-30
copies of this model, one per dept.) I was able to trim most of the data
pages from the 6MB file to get it to 3.5mb except for the sheet with all the
expenses.

I have used ideas from this forum to clear my temp files and have saved as
html to clear all the baggage from the file and I am still unable to move the
expenses sheet without getting memory errors--first "Not enough memory"; then
"Unable to save external link values". What does this mean? Is my workbook
corrupt? Are the results of the formulas in the workbook correct? I'm
running Excel 2000 with 256KB memory. Short of retyping all the formulas,
this is as close as I can get to error-free file saving with all the formulas
and links. Seems others have larger files that don't have this problem so I
don't understand why my Excel cannot accomplish this change. Any advise
would be welcome

I created a budget vs actual model in Excel with several sheets of data,
vlookups, and indexing formulas on many of the sheets. Now I want to break
the data sheets into another workbook to reduce the file size and eliminate
duplication of data, among other problems. (We are planning about 25-30
copies of this model, one per dept.) I was able to trim most of the data
pages from the 6MB file to get it to 3.5mb except for the sheet with all the
expenses.

I have used ideas from this forum to clear my temp files and have saved as
html to clear all the baggage from the file and I am still unable to move the
expenses sheet without getting memory errors--first "Not enough memory"; then
"Unable to save external link values". What does this mean? Is my workbook
corrupt? Are the results of the formulas in the workbook correct? I'm
running Excel 2000 with 256KB memory. Short of retyping all the formulas,
this is as close as I can get to error-free file saving with all the formulas
and links. Seems others have larger files that don't have this problem so I
don't understand why my Excel cannot accomplish this change. Any advise
would be welcome


	VB:
	
 valuel2() 
     
     
    Dim wbNew As Workbook 
    Dim wbCurr As Workbook 
     
    Application.ScreenUpdating = False 
    Application.DisplayAlerts = False 
     
    Set wbCurr = ActiveWorkbook 
    Set wbNew = Application.Workbooks.Open(wbCurr.ActiveSheet.Range("C49") & wbCurr.ActiveSheet.Range("C51"), False, True) 
    LinkFileName1 = wbCurr.ActiveSheet.Range("C18") 
    LinkFileName2 = wbCurr.ActiveSheet.Range("C44") 
    LinkFileName3 = wbCurr.ActiveSheet.Range("C45") 
    LinkFileName4 = wbCurr.ActiveSheet.Range("C46") 
    LinkFileName5 = wbCurr.ActiveSheet.Range("C47") 
    LinkFileName6 = wbCurr.ActiveSheet.Range("C48") 
     
     
    wbNew.BreakLink Name:=LinkFileName1, Type:=xlExcelLinks 
    wbNew.BreakLink Name:=LinkFileName2, Type:=xlExcelLinks 
    wbNew.BreakLink Name:=LinkFileName3, Type:=xlExcelLinks 
    wbNew.BreakLink Name:=LinkFileName4, Type:=xlExcelLinks 
    wbNew.BreakLink Name:=LinkFileName5, Type:=xlExcelLinks 
    wbNew.BreakLink Name:=LinkFileName6, Type:=xlExcelLinks 
    Sheets("Check").Delete 
    Calculate 
    wbNew.SaveAs (wbCurr.ActiveSheet.Range("C20") & wbCurr.ActiveSheet.Range("e51")) 
    wbNew.Close 
     
    Application.ScreenUpdating = False 
    Application.DisplayAlerts = False 
End Sub 

If you like these VB formatting tags please consider sponsoring the author in support of injured Royal Marines
this doesn't work. why? well, the file doesn't contain every link thats listed...some contain all links some contain 1, others contain a mix of the ones listed- how can i get it to go through every file and ignore what it can't do (i.e. try to break the link to a non-linked file)?