BMW M3 Forum (E90 E92)

BMW Garage BMW Meets Register Search Today's Posts Mark Forums Read


Go Back   M3Post - BMW M3 Forum > BIMMERPOST Universal Forums > Off-Topic Discussions Board
 
PYSPEED
Post Reply
 
Thread Tools Search this Thread
      02-20-2013, 05:57 PM   #1
Hedges
Major General
 
Hedges's Avatar
 
Drives: 12 C63 AMG
Join Date: Jul 2008
Location: Toronto

Posts: 5,181
iTrader: (8)

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 on a server or something?
__________________
Hedges is offline  
0
Reply With Quote
      02-20-2013, 05:59 PM   #2
Red Bread
Brigadier General
 
Drives: My wife's car
Join Date: Oct 2008
Location: Dallas, TX

Posts: 4,243
iTrader: (0)

Garage List
PDF.
Red Bread is offline   United_States
0
Reply With Quote
      02-20-2013, 06:05 PM   #3
Hedges
Major General
 
Hedges's Avatar
 
Drives: 12 C63 AMG
Join Date: Jul 2008
Location: Toronto

Posts: 5,181
iTrader: (8)

Quote:
Originally Posted by Red Bread View Post
PDF.
How would i avoid it from being copied around if i change it to PDF? The excel sheet is fairly big with alot of Work Sheets inside the excel data.
__________________
Hedges is offline  
0
Reply With Quote
      02-20-2013, 06:20 PM   #4
Red Bread
Brigadier General
 
Drives: My wife's car
Join Date: Oct 2008
Location: Dallas, TX

Posts: 4,243
iTrader: (0)

Garage List
Quote:
Originally Posted by Hedges View Post
How would i avoid it from being copied around if i change it to PDF? The excel sheet is fairly big with alot of Work Sheets inside the excel data.
You won't really be able to lock it down 100%, people can still a screen cap, etc. But a PDF keeps you from being able to copy individual cells and ranges. For multiple tabs, you'd need to attach multiple PDF's. You can print directly to PDF if needed.
Red Bread is offline   United_States
0
Reply With Quote
      02-20-2013, 06:29 PM   #5
MrRoboto
Colonel
 
Drives: VO 1M
Join Date: Aug 2007
Location: Canada

Posts: 2,706
iTrader: (0)

IF they can view it they can copy it to some degree. You could always export the file or take a screen shot and save it as .jpg. They wouldn't be able to copy/paste the text but also removes the ability to search the file.
MrRoboto is offline   Canada
0
Reply With Quote
      02-20-2013, 06:34 PM   #6
ScreaM
Banned
 
Drives: M3
Join Date: Feb 2013
Location: AZ

Posts: 100
iTrader: (0)

You can password protect it..they wont be able to copy or modify it..only view

http://office.microsoft.com/en-us/ex...010078580.aspx
ScreaM is offline  
0
Reply With Quote
      02-20-2013, 07:10 PM   #7
Red Bread
Brigadier General
 
Drives: My wife's car
Join Date: Oct 2008
Location: Dallas, TX

Posts: 4,243
iTrader: (0)

Garage List
Quote:
Originally Posted by ScreaM
You can password protect it..they wont be able to copy or modify it..only view

http://office.microsoft.com/en-us/ex...010078580.aspx
Again, not really fool proof. A ctrl+prnt screen still works. If you don't want people to share, it's best to send a watermarked hard copy with a unique number as the watermark.
Red Bread is offline   United_States
0
Reply With Quote
      02-20-2013, 08:01 PM   #8
Hedges
Major General
 
Hedges's Avatar
 
Drives: 12 C63 AMG
Join Date: Jul 2008
Location: Toronto

Posts: 5,181
iTrader: (8)

Is there a way to lock it down so they cannot even copy a file away onto their own USB or something on top of not able to copy paste cells / change cells?

Like having the excel file on a server, users can just double click to open but make it impossible to move a file , copy paste , change the cells in excel? They can screen capture it which is fine i dont mind that, just as long as the file stays where it is on the server and can only be viewed.
__________________
Hedges is offline  
0
Reply With Quote
      02-20-2013, 08:18 PM   #9
b0bab0i
Captain
 
Drives: 03 TiAG z4 3.0i w/ hardtop
Join Date: Feb 2008
Location: SoCal

Posts: 965
iTrader: (0)

Quote:
Originally Posted by Hedges View Post
Is there a way to lock it down so they cannot even copy a file away onto their own USB or something on top of not able to copy paste cells / change cells?

Like having the excel file on a server, users can just double click to open but make it impossible to move a file , copy paste , change the cells in excel? They can screen capture it which is fine i dont mind that, just as long as the file stays where it is on the server and can only be viewed.
No
b0bab0i is offline  
0
Reply With Quote
      02-20-2013, 08:22 PM   #10
Foxrus14
1 SLY 1
 
Drives: Sleeper Until the key turns
Join Date: Jan 2013
Location: Charlotte, NC

Posts: 173
iTrader: (0)

Send a message via Skype™ to Foxrus14
Get them all in a room and present it... Then no one even has a copy.... That's the only lock down method.
__________________
2013 X1 35i M Sport - Mine
2012 135i M Sport - Wifey
2014 ZL1 - Mine
2014 Harley Davidson Street Glide Special - Mine
2014 Harley Davidson Breakout - Wifey
Foxrus14 is offline   United_States
0
Reply With Quote
      02-21-2013, 02:34 PM   #11
bimmerfrk
Private First Class
 
bimmerfrk's Avatar
 
Drives: Alpine White 2011 M3 4dr
Join Date: May 2012
Location: NYC & some PA

Posts: 161
iTrader: (0)

Sorr this is not possible. People can just take a pic with a camera phone. Rethink your approach.....

Why not had out printed media and the recollec it......
__________________
2011 M3 Sedan : Alpine White / Fox Interior : Escort X50 Hardwired
bimmerfrk is offline  
0
Reply With Quote
      02-21-2013, 06:46 PM   #12
Hawkeye
Brigadier General
 
Hawkeye's Avatar
 
Drives: '07 Z4 si Coupe, '08 R6
Join Date: Aug 2007
Location: Holland

Posts: 3,594
iTrader: (0)

Garage List
Quote:
Originally Posted by Hedges View Post
Is there a way to lock it down so they cannot even copy a file away onto their own USB or something on top of not able to copy paste cells / change cells?

Like having the excel file on a server, users can just double click to open but make it impossible to move a file , copy paste , change the cells in excel? They can screen capture it which is fine i dont mind that, just as long as the file stays where it is on the server and can only be viewed.
If it is going to be on network just password protect the file from anything and then set the network settings for that file so that nobody can copy it.


***Alternative solution****
What I would do if I was so paranoid is I would password protect all numbers and sheets so they could not be messed with in the file and I would put a macro in that checks the file path upon opening and if it is not the location that you put it (hardcoded in the macro) then erase all contents.

Really easy macro to write if you need help.

edit: If you do that make sure that you keep your master copy without that macro enabled. A simple connection error could possible make it not realize the filepath correctly.
__________________
2007 Z4 3.0si Coupe 6 MT Black Saphire Metallic PP SP Heated M Seats Clutch Stop Stubby
2008 R6 Raven Black GPR Steering Stabilizer Comp Werks FE Hotbodies Flush Mount Blinkers
2008 Nissan Titan XE King Cab Long Bed 4x4 Line-X
Hawkeye is offline   No_Country
0
Reply With Quote
Post Reply

Bookmarks

Thread Tools Search this Thread
Search this Thread:

Advanced Search

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 Off
Forum Jump


All times are GMT -5. The time now is 03:54 AM.




m3post
Powered by vBulletin® Version 3.7.0
Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.
1Addicts.com, BIMMERPOST.com, E90Post.com, F30Post.com, M3Post.com, ZPost.com, 5Post.com, 6Post.com, 7Post.com, XBimmers.com logo and trademark are properties of BIMMERPOST