restrict changes to worksheet

  • Thread starter Thread starter EdWeitz
  • Start date Start date
E

EdWeitz

I have two worksheets. The first one is used as a
report. The second Worksheet is where I paste my data,
and link the cells to the first worksheet. The data in
the cells on the second worksheet change daily. I have
had a problem with the formulas somehow getting changed.
Is there someway I can prevent the formulas from being
changed?
 
You can protect your worksheet. This will not allow any changes to the cells
unless you turn the protection off.

To do this, click on sheet 1 and under your menu go to Protection - Protect
Worksheet.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Copy cells from one worksheet to another workseet - increment row & do again 0
formulas change when copied 6
Vlookup Reference Certain Worksheets 4
Excel Columns moving up and down on their own in a worksheet. What Goes? 2
Excel VBA 1
VBA Excel - Select a value from one cell in Excel to update a SQL table 1
Linking worksheets, rearranging rows. 1
Formulas Across Worksheets 1

Back
Top