E46 BMW Social Directory E46 FAQ 3-Series Discussion Forums BMW Photo Gallery BMW 3-Series Technical Information E46 Fanatics - The Ultimate BMW Resource BMW Vendors General E46 Forum The Tire Rack's Tire Wheel Forum Forced Induction Forum The Off-Topic The E46 BMW Showroom For Sale, For Trade or Wanting to Buy

Welcome to the E46Fanatics forums. E46Fanatics is the premiere website for BMW 3 series owners around the world with interactive forums, a geographical enthusiast directory, photo galleries, and technical information for BMW enthusiasts.

You are currently viewing our boards as a guest which gives you limited access to view most discussions and access our other features. By joining our free community you will have access to post topics, communicate privately with other members (PM), respond to polls, upload content and access many other special features. Registration is fast, simple and absolutely free so please, join our community today!

If you have any problems with the registration process or your account login, please contact contact us.

Go Back   E46Fanatics > Everything Else > The Off-Topic > General Off-Topic

General Off-Topic
Everything not about BMWs. Posts must be "primetime" safe and in good taste. You must be logged in to see sub-forums.
Click here to browse all new posts.

Reply
 
Thread Tools Search this Thread Rate Thread Display Modes
Old 02-20-2013, 05:56 PM   #1
Hedges
Registered User
 
Join Date: Jun 2006
Location: Toronto
Posts: 431
My Ride: C63 AMG
Excel Gurus come in!

I have a fairly large Excel file full of critical information i would like other users / workers to view. However I want them to be able to only view it without making changes , without editing and most of all without being able to copy the file away. Is there a way to disable all this and still share the file out safely?
__________________
Hedges is offline   Reply With Quote
Old 02-20-2013, 06:45 PM   #2
Andy2108
Registered User
 
Join Date: Nov 2009
Location: U.S.A.
Posts: 8,039
My Ride: E46 M3, '67 Cobra
Google Docs or Drive or whatever they're calling it these days
__________________


De gustibus non est disputandum.
Andy2108 is offline   Reply With Quote
Old 02-20-2013, 07:40 PM   #3
ThEnder
Registered User
 
Join Date: Feb 2008
Location: Bay Area, CA
Posts: 449
My Ride: has twin turbos
Newer versions of Excel allow you to set two passwords: one to open, one to modify. Simply set a password to modify and email it out.

You could also share with Google Docs and invite people as read only as stated above.

Edit: Or you could save it as PDF.
__________________

Last edited by ThEnder; 02-20-2013 at 07:41 PM.
ThEnder is offline   Reply With Quote
Old 02-20-2013, 11:01 PM   #4
C4RLOS
Registered User
 
Join Date: Jun 2006
Location: Seattle, WA
Posts: 1,953
My Ride: 2003 325Ci
It should be something like this...

1. Highlight all of the cells by clicking the square between row 1 and column A
2. Format > Cells > Protection > Check "locked"
3. Tools > Protection > Protect Sheet
4. Uncheck all boxes and click OK
__________________


FOR SALE: pre-facelift sideskirts and front and rear bumpers | 19" hyperblack VMR V715 wheels (in sig)

C4RLOS is offline   Reply With Quote
Old 02-20-2013, 11:02 PM   #5
C4RLOS
Registered User
 
Join Date: Jun 2006
Location: Seattle, WA
Posts: 1,953
My Ride: 2003 325Ci
Preventing someone from copying the file away, however, is going to be difficult.
__________________


FOR SALE: pre-facelift sideskirts and front and rear bumpers | 19" hyperblack VMR V715 wheels (in sig)

C4RLOS is offline   Reply With Quote
Old 02-20-2013, 11:04 PM   #6
bimmerfan08
Registered User
 
Join Date: Feb 2009
Location: Cornwallis had his final ass kicking
Posts: 4,892
My Ride: E46 M3
Lock the cells

http://www.online-tech-tips.com/ms-o...ways-remember/
__________________


Quote:
Originally Posted by Big Rick View Post

Had to turn off the TV... Fox was making more sense than anyone else.

The rest of the world must be laughing at us now. It is so bad slipping to third world status...

Last edited by bimmerfan08; 02-20-2013 at 11:05 PM.
bimmerfan08 is offline   Reply With Quote
Old 02-20-2013, 11:07 PM   #7
Hedges
Registered User
 
Join Date: Jun 2006
Location: Toronto
Posts: 431
My Ride: C63 AMG
Basically what is a way to securely share a excel document so no one can copy it, change it, or even copy the whole file away.
__________________
Hedges is offline   Reply With Quote
Old 02-20-2013, 11:12 PM   #8
klangford
I got nothin'
 
Join Date: Feb 2003
Location: St. Augustine, FL
Posts: 326
My Ride: 07 Maserati QP
Send a message via AIM to klangford
Quote:
Originally Posted by Hedges View Post
Basically what is a way to securely share a excel document so no one can copy it, change it, or even copy the whole file away.
Easy - project it on a wall but take away their phones first
__________________
91 NSX - SOLD
99 328i - SOLD
2001 M3 - SOLD
2000 328i - Daughter's first BMW
2007 Maserati Quattroporte - my current ride
klangford is offline   Reply With Quote
Old 02-20-2013, 11:17 PM   #9
scott0482
Registered User
 
Join Date: Feb 2008
Location: Arlington, VA
Posts: 675
My Ride: 2001 530i
Send a message via AIM to scott0482
Is this on a shared drive or something?
One thing people do is make a file that references other files, so they can only view the info you want them to view in the main document, but the underlying data is in separate excel documents in a location that they do not have permission to access..
__________________
scott0482 is offline   Reply With Quote
Old 02-21-2013, 12:30 AM   #10
rohde88
Registered User
 
rohde88's Avatar
 
Join Date: Jan 2004
Location: Dallas, TX
Posts: 855
My Ride: S2000
nothing can stop screen caps
__________________
-Ron
rohde88 is offline   Reply With Quote
Old 02-21-2013, 12:50 AM   #11
evilstar
Registered User
 
Join Date: Mar 2008
Location: Inland Empire, SoCal
Posts: 19,131
My Ride: 633csi & 325i
Quote:
Originally Posted by scott0482 View Post
Is this on a shared drive or something?
One thing people do is make a file that references other files, so they can only view the info you want them to view in the main document, but the underlying data is in separate excel documents in a location that they do not have permission to access..
This might be your best bet. Also locking and protecting the sheet is not always enough you have to protect the files VB access or people can use a script to unlock the file. Ive done it not hard if you know how.
evilstar is offline   Reply With Quote
Old 02-21-2013, 12:51 AM   #12
evilstar
Registered User
 
Join Date: Mar 2008
Location: Inland Empire, SoCal
Posts: 19,131
My Ride: 633csi & 325i
Quote:
Originally Posted by rohde88 View Post
nothing can stop screen caps
there is software that does block that feature. not sure if it can be set as a group policy but it maybe possible.
evilstar is offline   Reply With Quote
Old 02-21-2013, 12:54 AM   #13
C4RLOS
Registered User
 
Join Date: Jun 2006
Location: Seattle, WA
Posts: 1,953
My Ride: 2003 325Ci
Snapchat
__________________


FOR SALE: pre-facelift sideskirts and front and rear bumpers | 19" hyperblack VMR V715 wheels (in sig)

C4RLOS is offline   Reply With Quote
Old 02-21-2013, 12:54 AM   #14
tock172
Beachtown Bill Collector
 
tock172's Avatar
 
Join Date: Jan 2011
Location: San Diego
Posts: 2,921
My Ride: '99 Techno Violet M3
#pivottable
__________________


1999 Techno Violet Metallic M3
Bilstein | Kosei K1 Racing | Toyo Proxes R888 | BMW CCA #430881

tock172 is offline   Reply With Quote
Old 02-21-2013, 01:17 AM   #15
GhostFlame
Registered User
 
Join Date: Jun 2011
Location: oceans
Posts: 193
My Ride: LSB/HPF
Quote:
Originally Posted by rohde88 View Post
nothing can stop screen caps
^^

screenshot > image to PDF > run Adobe OCR = everything readable again.
__________________
GhostFlame is offline   Reply With Quote
Old 02-21-2013, 01:49 AM   #16
Dinan e36
Registered User
 
Join Date: Jul 2004
Location: Griffin's Browser History
Posts: 386
My Ride: LEXUS IS350
Send a message via AIM to Dinan e36
try sharepoint
__________________
Dinan e36 is offline   Reply With Quote
Old 02-21-2013, 03:35 AM   #17
BruceWonder
Registered User
 
Join Date: Jan 2005
Location: CA
Posts: 2,220
My Ride: 2011.5 E92 M3
google docs - view only share
__________________
BruceWonder is offline   Reply With Quote
Old 02-21-2013, 03:38 AM   #18
b0bab0i
Registered User
 
Join Date: Jun 2005
Location: so cal
Posts: 798
My Ride: x
Quote:
Originally Posted by C4RLOS View Post
Snapchat
You can screenshot phones and use same method ghostflame mentioned.
__________________
b0bab0i is offline   Reply With Quote
Old 02-21-2013, 06:24 AM   #19
pancakes
Registered User
 
Join Date: May 2010
Location: Camelot
Posts: 86
My Ride: ///M, GTI, SUPERMOTO
I recall using a really old version of excel (or maybe openoffice?) to open a heavily protected newer excel sheet once... stripped all the passwords right off.
__________________

Last edited by pancakes; 02-21-2013 at 06:24 AM.
pancakes is offline   Reply With Quote
Old 02-21-2013, 09:27 AM   #20
Hedges
Registered User
 
Join Date: Jun 2006
Location: Toronto
Posts: 431
My Ride: C63 AMG
Quote:
Originally Posted by scott0482 View Post
Is this on a shared drive or something?
One thing people do is make a file that references other files, so they can only view the info you want them to view in the main document, but the underlying data is in separate excel documents in a location that they do not have permission to access..
That is a very good idea! Yes it can be on a shared drive second i figure out how to present the excel file. What program would make file references from an excel file?
__________________
Hedges is offline   Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is On
Censor is ON





All times are GMT -5. The time now is 02:08 AM.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.
(c) 1999 - 2011 performanceIX Inc - privacy policy - terms of use