Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Want Excel to break links between worksheets in same file
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 |
#2
|
|||
|
|||
What kind of link, inserted hyperlinks or just
=another_sheet!A5 if the latter just copy all the formulas and paste special as values in place, if former just right click and remove hyperlink Regards, Peo Sjoblom "eclectic_kx" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel links | Excel Discussion (Misc queries) | |||
Multiple worksheets open on starting Excel. | Excel Discussion (Misc queries) | |||
Edit Links in excel....Urgnet.. | Excel Discussion (Misc queries) | |||
How to recover worksheets lost when I opened an Excel file in Wor. | Excel Worksheet Functions | |||
Why do my links break when I burn multiple Excel files to a CD? | Excel Worksheet Functions |