View Single Post
  #2   Report Post  
Greg
 
Posts: n/a
Default

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?