+ Reply to Thread
Results 1 to 2 of 2

restrict changes to worksheet

  1. #1
    EdWeitz
    Guest

    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. #2
    Greg
    Guest

    RE: restrict changes to worksheet

    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 to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1