In Excel 2007 Why Doesn't Locking And Protecting Cells Work
Mar 18, 2011
I've created a workbook with about 15 worksheets and prior to sending to the customer I want to lock the cells so that they can't be changed without a password. So, I first select the cells I don't want to be altered and lock them. Then I go to "protect worksheet" and after checking the box that allows people to select cells in the locked section (selection of sells in unlocked section checks automatically) I enter a password twice and the worksheet is theoretically locked.
I can still change cells in the locked area. It didn't work on any of my worksheets. So I went back and unprotected the sheets and then selected and locked the cells TWICE, after which I protected the worksheets again. This time some, but not all, of the worksheets had locked the cells protecting them from editing. I then tried to go thru the same rigmarole but locking the cells three or four times before protecting the sheets for the sheets that were still unlocked, but that only worked sporadically as well. Sometimes I had to dis-allow selection, lock the cells in the sheet, unprotect it, lock the cells again twice, and then check the select box and protect the sheet AGAIN. That FINALLY worked.
I created a five year pro forma financial model for my business. The spreadsheet makes extensive use of worksheet formulas and macros. I also added a sheet to track actuals (numbers extracted, by hand, from QuickBooks monthly).Certain formulas in the spreadsheet are based on values that do not change over time. For example, I assume that my widgets will sell for some unit price and monthly revenue forecasts are calculated as the projected sales volume times the unit price.Here's the problem - let's assume that my sales price changes at some point in time, after sales revenue has been generated. If I simply change the price, which is applied globally, then the historical 'projections' will be wrong.Just to be clear: When the model was first built, it assumed that widgets sell for $100 apiece. Assume that unit sales are the same as the month number. Thus, my revenue for the first six months would be $100, $200, $300, $400, $500, and $600. Assume that for the first three months, I hit my revenue numbers. In this case, the sheet that tracks actuals would show a $0 difference, for each of the first three months, between projected revenue and actual revenue. Since business is doing so well, I decide to increase the price of the widgets to $150 on a forward-going basis. Suddenly, the spreadsheet now shows that I failed to meet projections for the first three months, when, in fact, I did meet them!It seems to me that there should be some way to lock cells in the spreadsheet based on the current date. For example, when I open the spreadsheet in June, I should be able to programmatically protect cells from May and earlier. Is this possible?
I have numbers e. g. 1 to 100 in excel in a particular column. If I remove any number e. g. 13 & keep that cell blank. Further cells should get automatically numbered from 13 onwards.
Been having some problems with excel getting it to behave like Iwanted, tried google around but so clueless as to what to call things that it makes it hard. What I want is for a cell formula to do as I want when I pull on the lower-right corner down.Normally it the adds 1 to every cell address, but I need some of them to remain the same while others change. More exact:I'm trying to make excelsheet where one collum is supposed to have the formula:
=F3*Dx/D3
x goes from 3 to eternity, while F3 and D3 should remain static while doing that drag thing. I remember there was a way to mark F3 and D3 so they don't change, but can't remember how.So F4 has F3*D4/D3, F5 has F3*D5/D3 and so fourth.
I bought a pc with Windows 7 that has worked fine with Word (office 2007). However, when I save a file with Excel 2007 and then call it up, the ribbon no longer works (I click on the various commands and ribbons don't pop up). Likewise, I cannot make cell entries or try operations like sorting. However, the program has not frozen since I can click on the various worksheets on the bottom. Is this an Excel or Windows problem and what is the solution.
I have installed my office 2007 in my new computer. Everything seems to work fine, except the Autocorrect function. I always use this function to add new corrections - or formatted texts. It has always worked well in Windows XP and Vista, but not on this Windows 7.)
I have Office 2007 on Windows 7.When I am working on a sheet (or document) the ribbon can become inaccessible, nothing works when I click it (like a 'Not Responding' screen).If, I switch to another open sheet/doc and then switch back the ribbon is accessible again!I have uninstalled/reinstalled Office plus SP's twice but the problem persists, and, as is usually the case, this does not happen all the time but enough times for it to be really annoying!
In XP, and previous IE's we'd click on a link to an excel file and it would pop up within IE, so we could quickly view it. I would like this in IE9, I have not had luck searching for a solution to this in Windows 7/IE9
I cannot open embedded pdf file in Excel 2007 and Excel 2010.When I try to open it, I get a message: Cannot start the source application for this object.I checked the registery, the path is correct.HKEY_CLASSES_ROOTCLSID{B801CA65-A1FC-11D0-85AD-444553540000}LocalServer32 I cleared [ ]Enable protected mode at startup in Adobe Reader X.Unfortunately, it still doesn't work.
I have Office 2007 running on a Windows 7 64 bit Toshiba laptop. I am trying to separate the data and time in an Excel file in one column and put the date in one column and the time in another.
I recently upgraded from 32-bit Windows Vista to 64-bit Windows 7 (did a clean OEM install). Now, my Microsoft Excel 2007 runs at a snails pace. Actually, I would be happy if it ran at a snails pace since it currently is running slower than that! It's almost to the point of being unusable. Opening an Excel document that took mere seconds with my 32-bit Vista now takes minutes with 64-bit Windows 7. Saving an Excel document in Vista took seconds and now easily takes 2-3 minutes with the new OS. Inserting a pivot table when my OS was 32-bit Vista was a snap, but now trying to do it working under 64-bit Windows 7 I can walk away and go eat dinner and come back and it still won't be done inserting the table.
Is there some known compatibility problem between MS Office/Excel 2007 and 64-bit Windows 7 OS? Ive searched Google but can't find anything related to the problem I am having.
I've tried restarting the PC. I reinstalled Office. I've tried launching Excel in compatibility mode for XP and Vista. All to no avail.
System Specs: CPU = Intel Core 2 Quad Q6600 2.4 GHz Mobo = nVidia 650i Core 2 Quad (EVGA nForce 650i Ultra) RAM = 4 gigs DDR2 Corsair at 1066 MHz dual channel HD = Western Digital Raptor 10k RPM 16 MB cache SATA Extreme Speed OS = 64-bit Windows 7 SP 1 MS Office = 2007 version with SP 1 (or 2, can't recall exactly).
I was recently upgraded to Windows 7 and Office 2010. Under my old version of Windows XP & Office XP/07, when I received an emailed spreadsheet & made adjustments to it, I was able to save it directly over the old emailed file. Now when I make any changes I am asked to save a copy of the file & to save it elsewhere on my computer & cannot save it directly over the original emailed spreadsheet. how to get this old feature back? I'm sure it's just a matter of ticking some option off.
Had to re-format HD, and seems to be working now.But for how much longer, who knows.On the old setup, I had MS WORD and Excel.Many existing files of both.I only have, if I remember right, 2 or 3 downloads allowable/available from the Student Edition of them that I purchased a while ago.So, I don't want to use up what is left on my present PC, as I have real doubts about it lasting much longer.I heard about Open Office, and that it is free, and "completely" compatible with the MS equivalents. True? Are there "better" free ones that would work very well with my existing WORD and Excel stuff?
I've just installed Windows 7-64 and Office 2007. When I open Outlook the window size is half the screen. I would like it bigger and drag the bottom of the window to the bottom of the screen. When I close Outlook and re-open, it reverts to the old window size and does not remember what I had set it to. How can I get it to remember the size it want?
I was previously running Windows 7 on an IDE Seagate HD (Master) with a second HD for all my music/audio work (slave).I've recently treated myself to a new Crucial M4 SSD which is now my C drive, with Windows and all my apps installed. I'm using my old seagate drive as a back-up of this (cloned) and my old audio drive as before - all my music and work.Should work fine - but my Audio drive is now write-protecting itself. I've tried wiping and re-formatting the drive, which worked until I restarted and the write-protection returned. I've tried using the 'diskpart' command and again, worked only temporarily.
I recently bought a new laptop and I installed Office 2007 on it (it had already been installed on other computers before). However, pressing Shift + Tab in Word doesn't decrease indent (It does so on PowerPoint). This does so on my other computers, and I assumed it was a default function in Word 2007. I tried to customize the keyboard shortcut for it, but Word wouldn't accept Tab as a suitable shortcut key (instead of registering Tab as part of the shortcut key combination, it performed the normal Tab function and went to the next gui object). Is there any way to fix this? I can live with it, since all I have to do is make a shortcut without Tab, or just simply click the respective buttons, but the Shift + Tab shortcut is ingrained in my memory and will be hard to unlearn, especially since any other computer I use with Word will use the default shortcut.
In about a week, I will be starting my own intro to Windows 7.
It is an enforced introduction as my XP m/c failed on Saturday. I know that I will have some software issues with Photoshop CS2 for example but I am hoping that Office 2007 works OK.
i have network backup utility that requires that i mount some network drives as the SYSTEM user. i created a bacth file to run at logon that works great.my issue is that this batch file contains plain-text password(s) that i would rather not have sitting there between logons.is there an easy way to fix this? another batch file that locks the 1st one after it is in use? i don't really know how to proceed here.i could make the batch file into an .exe archive with winrar, but is there a way to set up task scheduler to run a password protected .exe?
I keep a lot of confidential information on both my C: and an external hard drive. Is there a way for me to password protect the folders and files on these drives?
I have a starter edition of windows 7 that came pre-installed on my HP 110 series mini. I also have a 2007 ms office proffessional CD (even though I plan only to install word, excel, outlook). Will my mini be able to handle those features of MS Office I have described (word, excel, and outlook)? In the event I will need to upgrade, what should I get? Also, would it help if I left out excel ?
a) change the text on the Windows 7 boot screen in a multi boot situation from "Previous Version of Windows" to "Windows XP" for instance.
b) To actually password protect the menu so that only a certain user could boot into a particular OS .
I don't really want to use a 3rd party boot manager - but of course I suppose the other philosphy is if a user is not authorised to a particular application then why show it on the menu as a possible choice.
There should be some way of getting a logon prompt at boot and depending on the users privilege level display the boot options.
Another question -- On Windows 7 the XP partition is hidden (in Windows explorer).
On XP the Windows 7 system files are "viewable" as a separate disk drive. I like the hidden partition idea much better as the OS shouldn't be aware of the other OS.
This to me seems a not very good idea to allow the possibility of "tampering" with system files - especially by a previous version of an OS.
I could almost understand it if Windows 7 showed the XP system disk but not the other way round.
I have been running Windows 7 Ultimate (64bit) on my computer since December '10 and installed sp1 in February and had noticed no problems. I also have been using Microsoft Office 2007 Ultimate since I first installed the operating system. Now, I cannot use any of my Office Applications. I get an error message stating that "the operating system is not presently configured to run the program". I can't really recall using any of the programs since I installed the service pack. I have run the microsoft genuine software test application and my software checks out fine.
The other day i had a friend delete some programs from my Asus laptop on startup and running processes to make my computer boot up faster. I think we did something that makes the fn key not work anymore. how to restore this functionality?
