Home |
Search |
Today's Posts |
#1
|
|||
|
|||
restrict changes to worksheet
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? |
#2
|
|||
|
|||
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. "EdWeitz" wrote: 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Weekly Transaction Processing | Excel Worksheet Functions | |||
Indirect reference from one worksheet to another | Excel Worksheet Functions | |||
Executing macro for all worksheet from a different worksheet | New Users to Excel | |||
Reference Data in Moved Worksheet | Setting up and Configuration of Excel | |||
Worksheet name and Backward compatibility | Excel Discussion (Misc queries) |