 Excel '03: Making Document Un-Saveable |
Welcome Guest ( Log In | Click here to Register a free account now! )
Register a free account to unlock additional features at BleepingComputer.com
Welcome to Bleeping Computer, a free community where people like yourself come together to discuss and learn how to use their computers. Using the site is easy and fun. As a guest, you can browse and view the various discussions in the forums, but can not create a new topic or reply to an existing one unless you are logged in. Other benefits of registering an account are subscribing to topics and forums, creating a blog, and having no ads shown anywhere on the site.  |
 Oct 16 2009, 11:28 AM
Post
#1
|
|
|
Senior Member  Group: Members Posts: 385 Joined: 25-October 08 Member No.: 249,836  |
People are supposed to be able to: -enter personal info (credited to, etc) -enter miles driven -enter costs incurred I have been able to lock the calculations in the cells that give a grand total for all expenses, as well as calculating mileage (so people don't accidentally put their milage in the wrong box). Those cells are un-editable now. Now, since everyone in the company access this off the network, I need to prevent people from accidentally saving it. They still need to fill it out, so they can print and submit to their department heads. I didn't see an option when I was enabling sheet protection to do this. What did I miss? |
 |
 
|
|
Oct 16 2009, 10:07 PM
Post
#2
|
|
|
BleepIN--BleepOUT Group: Members Posts: 1,234 Joined: 21-October 04 Member No.: 3,911 |
Sharing a workbook is not simple in Excel. At least in 2000 we've seen some issues.
But there's nothing to stop you from trying. I would start by clicking the HELP button and typing "share workbook". Why? so that you can get the entire picture of what is involved. Please read all the helps. One of the first ones I'd look at is "About worksheet and workbook protection", the latter being what you're after. Then I'd read "Edit a shared workbook" section as this shows how to place certain restrictions. Good luck. It'll work after you get all the requirements figured out. |
|
|
|
|
Oct 17 2009, 12:25 PM
Post
#3
|
|
 Bleepin' Night Watchman Group: Moderator Posts: 4,872 Joined: 5-December 05 From: The City of Saint Francis, by the western sea Member No.: 43,307 |
Why not make it read only (on the operating system level) and/or change the permissions to deny modification?
-------------------- |
|
|
|
|
Oct 18 2009, 11:57 AM
Post
#4
|
|
|
Senior Member Group: Members Posts: 385 Joined: 25-October 08 Member No.: 249,836 |
XD, thanks Andrew. Forgot about that! Stupid me.
|
|
|
|
|
Nov 4 2009, 12:08 PM
Post
#5
|
|
 Member Group: BC Advisor Posts: 48 Joined: 4-November 09 From: Leeds, UK Member No.: 398,528 |
Further to all this, I would save the original file in your own area as a backup copy, then save the one you want people to work from as a template.
Then if people double click the file, they automatically get a new workbook as a copy rather than opening the file itself. Downside is if people use file > open to get to it, then they will open then template and their save as... will also be a template (but no real harm in that). Best option is to talk to your IT sysadmins and put it in a share folder which can be used for workgroup templates (a setting you can fix using group policy). Then people don't have to browse, they just do file > new > pick a file (your expenses template in this case). You don't mention which version of Excel you and the other staff are using. If it's 2007 then consider using office button > prepare > mark as final. This will always open as read only from then on. Do the same in reverse to make changes saveable. If 2000/2003 when you do save as, look at the top right for tools menu > general options > tick the box for "read only". This will remind people they should only open this read only, but that can be annoying as it is another dialog box to get rid of. Changing attributes to make something read only is usually the simplest way, but be wary if the files get moved around a lot or backed up and restored that this attribute might get lost along the way. -------------------- Due to global warming, eskimos now have more than 20 words for water John O'Farrell
Professional geek, consultant and trainer. MCT, MCSA, MCAS:I, MBMSS, CWNA, COS (I like to have lettuce after my name) My personal blog - Getting IT right |
|
|
|
|
1 User(s) are reading this topic (1 Guests and 0 Anonymous Users)
0 Members:
| Lo-Fi Version | Time is now: 21st March 2010 - 03:58 AM |
© 2003-2010 All Rights Reserved Bleeping Computer LLC.