Linked workbooks

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Windows 2000, Office 200

Have several workbooks linked to a single workbook. At beginning of month email the previous month's workbook to staff. When they open to workbook they are prompted that the workbook contains links to other workbooks and do they want to update. I don't want them to have the option to update the workbook because I don't want them to see the current month's data being input. How do I prevent this. There are approx 15 workbooks (each with approx 6 worksheets) that are being distributed so needs to be an easily implemented solution
 
If you just want them to see the data, do the following: use Ctrl+A to
select the entire page in each sheet tab. Then Ctrl+C to copy it, and Ctrl+V
to paste it in the same place. A drop down box will appear; select "Values
only." Then, only the values will appear and there will no longer be any
external links.

If you are using an earlier version of Excel than XP, you will need to
select Edit-Paste Special rather than Ctrl+V.

Cheryl said:
Windows 2000, Office 2000

Have several workbooks linked to a single workbook. At beginning of month
Click to expand...
email the previous month's workbook to staff. When they open to workbook
they are prompted that the workbook contains links to other workbooks and do
they want to update. I don't want them to have the option to update the
workbook because I don't want them to see the current month's data being
input. How do I prevent this. There are approx 15 workbooks (each with
approx 6 worksheets) that are being distributed so needs to be an easily
implemented solution.
 
Windows 2000, Office 2000

Have several workbooks linked to a single workbook. At beginning of month email the previous month's workbook to staff. When they open to workbook they are prompted that the workbook contains links to other workbooks and do they want to update. I don't want them to have the option to update the workbook because I don't want them to see the current month's data being input. How do I prevent this. There are approx 15 workbooks (each with approx 6 worksheets) that are being distributed so needs to be an easily implemented solution.
Click to expand...

1. Select the Sheet in your linked workbook that you want to
disseminate to staff and copy it into a new workbook. (Press Edit,
then Move or Copy Sheet.)

2. In the popup check "Create a Copy" and choose the "(new book)"
option.

3. Open your new book and highlight all of the cells of your report.

4. Copy the selected cells and then paste them right back where they
were, but using the Paste Special option.

5. In the Paste Special popup box check "Values" and press the "OK"
button. Then press the Esc key. NOTE: You may need to repeat these
steps to transfer formatting or comments or other desirable
characteristics that were not transferred from the original worksheet.

This process will give you a workbook that is devoid of the links you
have in your working papers.
 
Back
Top