Computer Help and Spyware Removal Computer Help and Spyware Removal Computer Help and Spyware Removal Computer Help Forums Windows Startup Programs Database Virus, Spyware, and Malware Removal Guides Computer Tutorials Uninstall Database File Database Computer Glossary Computer Resources
 

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.
Click here to Register a free account now! or read our Welcome Guide to learn how to use this site.


 
Reply to this topicStart new topic
> Excel '03: Making Document Un-Saveable
DnDer
post Oct 16 2009, 11:28 AM
Post #1


Senior Member
****

Group: Members
Posts: 385
Joined: 25-October 08
Member No.: 249,836



I have an employee expense report I'm trying to fix up.

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?
Go to the top of the page
 
+Quote Post
tos226
post 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.
Go to the top of the page
 
+Quote Post
Andrew
post 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?


--------------------
Go to the top of the page
 
+Quote Post
DnDer
post 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.
Go to the top of the page
 
+Quote Post
AdamV
post 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
Go to the top of the page
 
+Quote Post

Reply to this topicStart new topic
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


Advertise   |   About Us   |   Terms of Use   |   Privacy Policy   |   Contact Us   |   Site Map   |   Chat   |   Tutorials   |   Uninstall List
Discussion Forums   |   The Computer Glossary   |   Resources   |   RSS Feeds   |   Startups   |   The File Database   |   Virus Removal Guides

© 2003-2010 All Rights Reserved Bleeping Computer LLC.