E90Post
 


TireRack
 
BMW 3-Series (E90 E92) Forum > BIMMERPOST Universal Forums > Off-Topic Discussions Board > Excel Gurus come in!



Reply
 
Thread Tools Search this Thread
      02-20-2013, 05:57 PM   #1
Hedges
Major General
Hedges's Avatar
61
Rep
5,180
Posts

 
Drives: 12 C63 AMG
Join Date: Jul 2008
Location: Toronto

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?
__________________
Appreciate 0
      02-20-2013, 05:59 PM   #2
Red Bread
Brigadier General
United_States
45
Rep
4,364
Posts

 
Drives: My wife's car
Join Date: Oct 2008
Location: Dallas, TX

iTrader: (0)

Garage List
PDF.
Appreciate 0
      02-20-2013, 06:05 PM   #3
Hedges
Major General
Hedges's Avatar
61
Rep
5,180
Posts

 
Drives: 12 C63 AMG
Join Date: Jul 2008
Location: Toronto

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.
__________________
Appreciate 0
      02-20-2013, 06:20 PM   #4
Red Bread
Brigadier General
United_States
45
Rep
4,364
Posts

 
Drives: My wife's car
Join Date: Oct 2008
Location: Dallas, TX

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.
Appreciate 0
      02-20-2013, 06:29 PM   #5
MrRoboto
Colonel
Canada
54
Rep
2,715
Posts

 
Drives: VO 1M
Join Date: Aug 2007
Location: Canada

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.
Appreciate 0
      02-20-2013, 06:34 PM   #6
ScreaM
Banned
1
Rep
100
Posts

 
Drives: M3
Join Date: Feb 2013
Location: AZ

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
Appreciate 0
      02-20-2013, 07:10 PM   #7
Red Bread
Brigadier General
United_States
45
Rep
4,364
Posts

 
Drives: My wife's car
Join Date: Oct 2008
Location: Dallas, TX

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.
Appreciate 0
      02-20-2013, 08:01 PM   #8
Hedges
Major General
Hedges's Avatar
61
Rep
5,180
Posts

 
Drives: 12 C63 AMG
Join Date: Jul 2008
Location: Toronto

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.
__________________
Appreciate 0
      02-20-2013, 08:18 PM   #9
b0bab0i
Captain
9
Rep
974
Posts

 
Drives: 03 TiAG z4 3.0i w/ hardtop
Join Date: Feb 2008
Location: SoCal

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
Appreciate 0
      02-20-2013, 08:22 PM   #10
Foxrus14
1 SLY 1
United_States
7
Rep
174
Posts

 
Drives: Sleeper Until the key turns
Join Date: Jan 2013
Location: Charlotte, NC

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
Appreciate 0
      02-21-2013, 02:34 PM   #11
bimmerfrk
Private First Class
bimmerfrk's Avatar
6
Rep
184
Posts

 
Drives: Alpine White 2011 M3 4dr
Join Date: May 2012
Location: NYC & some PA

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
Appreciate 0
      02-21-2013, 06:46 PM   #12
Hawkeye
Brigadier General
Hawkeye's Avatar
No_Country
44
Rep
3,594
Posts

 
Drives: '07 Z4 si Coupe, '08 R6
Join Date: Aug 2007
Location: Holland

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
Appreciate 0
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:20 PM.




e90post
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