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 |
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 |
All times are GMT +1. The time now is 02:25 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com