Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Excel links
I want to make sure that if I send out a spreadsheet with a linked
spreadsheet, that the people I send this to will not be able to open or display the linked infomation. Does excel make sure that this infomation cannot be displayed? |
#2
|
|||
|
|||
Excel links
Pete wrote:
I want to make sure that if I send out a spreadsheet with a linked spreadsheet, that the people I send this to will not be able to open or display the linked infomation. Does excel make sure that this infomation cannot be displayed? If the source file (to which your spreadsheet is linked) is not visible to the people receiving it (e.g. on the same network) then they will not be able to open it. They will normally be able to see the values that your formulas have extracted from that source workbook. You can reduce the visibility by hiding the worksheets containing the formulas and password protecting the workbook structure and/or by setting the formulas to be locked and hidden (Format / Cells / Protection) and password protecting the worksheets. Bill Manville MVP - Microsoft Excel, Oxford, England No email replies please - respond to newsgroup |
#3
|
|||
|
|||
Excel links
I really hate to sound like an nut case but ... I want to post a question to
this group. When I try to post I am asked to choose a discussion group. What group is this? "Bill Manville" wrote: Pete wrote: I want to make sure that if I send out a spreadsheet with a linked spreadsheet, that the people I send this to will not be able to open or display the linked infomation. Does excel make sure that this infomation cannot be displayed? If the source file (to which your spreadsheet is linked) is not visible to the people receiving it (e.g. on the same network) then they will not be able to open it. They will normally be able to see the values that your formulas have extracted from that source workbook. You can reduce the visibility by hiding the worksheets containing the formulas and password protecting the workbook structure and/or by setting the formulas to be locked and hidden (Format / Cells / Protection) and password protecting the worksheets. Bill Manville MVP - Microsoft Excel, Oxford, England No email replies please - respond to newsgroup |
#4
|
|||
|
|||
Excel links
microsoft.public.excel.links
Bill Manville MVP - Microsoft Excel, Oxford, England No email replies please - respond to newsgroup |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Data from Excel 2000 Worksheet with external links is not displayed when opened in Excel 2003 | Links and Linking in Excel | |||
Creating Relative Links in Excel... | Excel Discussion (Misc queries) | |||
find and replace links in Excel 2003 | Excel Worksheet Functions | |||
How do I remove external links from Excel 2000 workbook? | Excel Discussion (Misc queries) | |||
How do I Break links Using Excel 2000 | Excel Discussion (Misc queries) |