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?

0
anonymous (74717)
1/31/2005 12:55:30 AM
excel.misc 78881 articles. 5 followers. Follow

1 Replies
416 Views

Similar Articles

[PageSpeed] 42

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?
> 
> 
0
Greg7423 (349)
1/31/2005 3:41:08 PM
Reply:

Similar Artilces:

Changing default typeface in Publisher?
How do you do above? Bob S wrote: > How do you do above? ======================== Maybe the following article will help: Setting Text Defaults using Normal.pub http://ed.mvps.org/Static.aspx?=Publisher/normal.pub -- John Inzer MS Picture It! - Digital Image MVP Digital Image Highlights and FAQs http://support.microsoft.com/ph/695 Notice This is not tech support I am a volunteer Solutions that work for me may not work for you Proceed at your own risk ...

Restricting Input
Ok, I'm on a roll here. Could someone please tell me how to set up a cell restriction that will only allow data input if another cell is "empty" or has a certain value? Kind of like an IF function, only when "true" exists, I can input any value, and when "false" exists, I must leave it blank. Thanks in advance. Randy, you can accomplish this using data validation. Select: data-validation, then input your restriction. Randy Vieira wrote: > Ok, I'm on a roll here. Could someone please tell me how to set up a cell > restriction that will ...

Font Problem
Why does my font change unexpectedly when the email is sent in Outlook 2002? I also have all recent service packs through SP3. I use HTML. I've tried the Mail Format tab options to change the fonts to always use my fonts and set everything to 10pt arial. It still arbitrarily changes its font size for no reason somtimes. Thanks ...

Change the owner of a workflow rule
We have several workflows that have been created but now need to change their owner. Can anyone advise on how this is possible. Hmmm, Assign message does not seem to support workflow entities. How about exporting workflow rules then reimporting them back under a new account? Just a thought. -- George Doubinski CRM Certified Professional - Developer "AneelK" <AneelK@discussions.microsoft.com> wrote in message news:025528FA-4880-4AB3-9EF7-C3709D10D3E4@microsoft.com... > We have several workflows that have been created but now need to change > their > owner. &g...

Save you changes
Found an annoying bug in the KB Manager. Often when adding new KB articles, once the article is published, I still get a dialog box asking me if I want to save my changes. There is no way to edit or save a published article (except to unpublish it first). Even after I unpublish and repeatedly save the article I continue to get this dialog box asking me "Are you sure you want to navigate away from this page?" Once you save and publish and article this warning should never happen. ...

how do you change column headings in excel?
how do i change the column headings from A, B, C etc to what i want them to be eg, Name, Address etc You can't, you can remove them and use the first row and column to create your own, to remove the built in do tools>options>view and uncheck row & column headers Regards, Peo Sjoblom "thickasawhaleomlette" wrote: > how do i change the column headings from A, B, C etc to what i want them to > be eg, Name, Address etc thick You can't change these. You can however, enter your titles in Row 1 then freeze row 1 so's it remains in view. Select A2 an...

Change Inbox View
Is there a way that I can adjsut the view of my Inbox so that the view in the right column is split with the top half showing my Inbox and the bottom half showing the calendar or tasks? Thanks for the help. No - when you're looking at your Inbox, you're looking at your mail only. Perhaps Outlook Today can do what you wish? Robbie wrote: > Is there a way that I can adjsut the view of my Inbox so > that the view in the right column is split with the top > half showing my Inbox and the bottom half showing the > calendar or tasks? Thanks for the help. ...

Revise an Append Query, or Change to an Update Query
I have a database which has worked well for a long time, until a recent change request. Now this change has identified a flaw in the original coding logic, can someone help me with this? The database processes an input file and produces an output table which is copied into Excel for graphing. The output table is where the problem is. The present logic wipes the table completely and then rebuilds the table using append queries. This works well EXCEPT when one of the ranges is ZERO, the current queries do not create a 0 entry for that range. Q1: Is there a simple way to mo...

Pricing restriction to price lists
Most of our customers do no wish to load all products to MS CRM. Therefore the system restriction to use price lists is too inflexible. In case of opportunities it is even not possible to enter manual prices on product level. ...

How to change chart properties.
Suppose you insert 2 charts "non programmatically" in an Excel worksheet (click Insert>Column>Stacked Colum for example). How would you change the chart properties programmatically? I've used the shapes collection, but that only worked for me with one chart. The problem is that I don't know how to differentiate between multiple charts. Is there some way to name the chart or shape somehow? For all this type of action try recording a macro which selects your chart, then changes the relevant properties. "cr113" wrote: > > Suppose you inse...

Template font/size changes when content deleted
Vista 32 Office 2007 however I save many documents in Word 97 I have created a new word (Word 97) template using font Arial and size 12. When I open that template it's title is "mine.dot" until I save it as a W97 i.e. "etc.doc". However, if I open that document that has been created using this template, highlight all, then delete the contents, the font/size reverts to Calibri/11 for any new text I type into that document; that is it doesn't retain the original font/size of Aial/12 as per the template used. Also using "Help" - Create a ne...

Worksheet 101
Hi, If someone changes the Store Account via HQ from "revolving" to "net 30" would issuing a Worksheet Style 101 then be used to update the accounts at the store locations? I ask because we are trying to determine who changed our Store Account Terms. It used to be set to revolving but was changed last Aug to Net 30 and no one (the accountants) seem to know who changed it and why they didn't inform the other users! And, of course, this is the first I am hearing of it a year later! Anyway, I am just trying to track down when the change was made and who ...

change password
The current RMS system does not require or give a cashier the ability to change their password. The only method for changing passwords is for someone with administrative access to the cashier menu option in manager to change the password. In order to comply with common password policies in most organizations, I would like to see the ability for a cashier to be able to change their own password. In addition, it would be preferred that they are required to change it on a schedule (90 days) and that the software gives the option of requiring a strong password. ---------------- This pos...

Macro to copy & paste-special-values data to selected worksheets
I have a workbook containing worksheets called “List-1”, “List-2”, “List-3”, “List-4” and many other worksheet “templates”. I need a macro to perform the following: 1. On any of the particular worksheet templates, copy the data on the entire row for all rows within the range A1:H50 only if the value for that row in column H is greater than 0, and then “paste special values” the data on the worksheet called “List-1” starting at cell A1. In other words, for any row within the range that has a value in column H that is greater than 0, the entire row of data in column A-H will be...

chart moving on worksheet
Dear experts, I have a worksheet with data that gets updated every week and I would like to add on top of it a chart that shows an analysis of this data as changes are made. When I say on top I really mean it - I would like the chart to always show on the top right-hand corner of the screen and stay there even when the users scroll the data on the worksheet. Of course it should be possible to move the chart if the users need to. Is this possible at all in Excel 2003? Many thanks in advance for your help! Best regards -- Valeria ...

Formatting changes in message replies.
I know I ought to know the answer to this but... My OE is set to Ariel for both composing and reading messages, and not to reply in the same format they are received. Yet I send a message to a friend who is using Outlook (I'm not v familiar with Outlook settings), which he says is set to Ariel, and when he replies, his part is in Ariel, but mine has been converted to Times. Which, if that is how it appears to others, he might send my stuff to, makes me look even more quaint and old fashioned than I really am! How might I tell him to correct this, or is there some way my...

Change multiple appts at once
I need to edit, save, and close multiple appts from other people at the same time ON MY PC (not send out updates). Is there any way to select several appts and change them all to All Day Event and Free Time at the same time? Our associates are supposed to post an all-day event, set to free, to other members of their teams when they'll be out of the office--and a separate event, set to Out of Office, that blocks out their individual calendars for the specific time they'll be out. Frequently, people either only do the second one or they forget to set the all-day event to ...

Font size changing on different computers
Having problems with header font changing size when opened on computer B. Both computers running Word 2003. Network shared letterhead template has Arial 12, 10 & 9 one size on each line. Created on Cmpt A and saved to shared network drive, opens on Cmpt B with font changed to 11, 10 and 10. Prints that way from Cmpt B, but saved to network and printed from Cmpt A, prints correctly. Letterhead is fine when opened on Cmpt B using template. Tried font substitution, but states no substitution necessary. Any ideas or suggestions? Thanks. Hi Bette Beau, With the documen...

Restrict calendar?
We are currently looking at moving to Exchange 2003 this year. Our employers are holding off on the purchase due to the fact that there is no way to restrict certain users from even being able to see "Free/Busy" on their calendars. They want it so that a whole Active Directory OU can be set to not have any calendar access to another OU's calendar. Does anyone know if this is possible? This is huge for us so a great big Thank You in advance to those who might have suggestion. sgsundqu wrote: > We are currently looking at moving to Exchange 2003 this year. Our > employe...

How to change CFileDialog Open button text
Using VC++ 6.0... I want to use the CFileDialog to allow the user to select a file to delete. I would like to change the text of the "Open" button to "Delete". Is there an easy way to do that, or do I need to go the route of creating a new dialog template based on the common dialog and add a button there? ....mcs Meade, You can derive from CFileDialog and do all kind of stuff in the class. Johan Rosengren Abstrakt Mekanik AB "Meade Swenson" <meade@ieee.org> a �crit dans le message de news:uxrqLzn8EHA.3820@TK2MSFTNGP11.phx.gbl... > Using VC++ ...

Restrictions
All of a sudden I am no longer able to click on hyperlinks embedded within email and get an error message "THIS OPERATION HAS BEEN CANCELLED DUE TO RESTRICTION IN EFFECT ON THIS COMPUTER. PLEASE CONTACT YOUR SYSTEM ADMINISTRATOR." I haven't knowingly changed anything but some other program may have. How do I get back to normal? See if the articles at http://support.microsoft.com/?kbid=3D310049 and http://support.microsoft.com/?kbid=3D307818 help with this.=20 --=20 Sue Mosher, Outlook MVP Author of Microsoft Outlook Programming - Jumpstart for=20 Administrator...

Pivot table range selection changes when opening 2003 xls in Excel 2007
Has anyone noticed that Pivot table range selection gets messed up when opening a Excel 2003 document in Excel 2007? This causes some of the data to be left out from the table, which causes confusion. How can I prevent this from happening. We don't wanna redo all the spreadsheets in Excel 2007..... Thanks. saqib http://doctrina.wordpress.com/ On Jun 22, 6:12=A0am, Saqib Ali <docbook....@gmail.com> wrote: > Has anyone noticed that Pivot table range selection gets messed up > when opening a Excel 2003 document in Excel 2007? This causes some of > the data to be left out ...

Change unit cost for Miscellaneous Items
Dynamics GP Sales Order Processing does not allow editing of unit cost for all item types. Please include an option to allow us to change the unit cost for for miscellaneous, service and flat fee items. ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. http://www.micro...

Can ADSI Edit change mailbox location?
I have two users that have mailboxes on servers that no longer exist. When I pull up their name to move their mailbox, since the server is no longer online, I can't move them. I could delete their account and start over, but I wondered if I could change a setting with ADSI edit and simply point their mailbox to the new server (somehow these two were missed.) I know there wouldn't be a mailbox, however, and that's kind of why I'm stuck. Was hoping for an idea or should I just delete them and start over? Thanks for any help. On 10 Jan 2007 12:38:12 -0800, "jmDesktop&qu...

How do I change the default comment formatting?
When I insert a comment I want to be able to change the formatting so it always comes up as a certain size with Arial 12pt font? Can someone please help? Hi see: http://www.contextures.com/xlcomments02.html#Default -- Regards Frank Kabel Frankfurt, Germany nick_aus80 wrote: > When I insert a comment I want to be able to change the formatting so > it always comes up as a certain size with Arial 12pt font? Can > someone please help? ...