|
|
|
|
|
|
BMW Garage | BMW Meets | Register | Today's Posts | Search |
|
BMW 3-Series (E90 E92) Forum
>
Excel Gurus come in!
|
|
02-20-2013, 04:57 PM | #1 |
Major General
116
Rep 5,178
Posts |
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?
__________________
|
02-20-2013, 05:05 PM | #3 |
Major General
116
Rep 5,178
Posts |
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, 05:20 PM | #4 |
Major General
4463
Rep 9,160
Posts |
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, 05:29 PM | #5 |
Brigadier General
1846
Rep 4,836
Posts |
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, 05:34 PM | #6 |
Banned
1
Rep 100
Posts |
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, 06:10 PM | #7 | |
Major General
4463
Rep 9,160
Posts |
Quote:
|
|
Appreciate
0
|
02-20-2013, 07:01 PM | #8 |
Major General
116
Rep 5,178
Posts |
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, 07:18 PM | #9 | |
Major
24
Rep 1,033
Posts |
Quote:
|
|
Appreciate
0
|
02-20-2013, 07:22 PM | #10 |
1 SLY 1
44
Rep 187
Posts |
Get them all in a room and present it... Then no one even has a copy.... That's the only lock down method.
__________________
2014 328i - Mine
2012 135i M Sport - Wifey 2014 z28 Hennessey 650 package - Mine 2014 Harley Davidson Street Glide Special - Mine 2014 Harley Davidson Breakout - Wifey |
Appreciate
0
|
02-21-2013, 01:34 PM | #11 |
Lieutenant
591
Rep 534
Posts |
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......
__________________
|
Appreciate
0
|
02-21-2013, 05:46 PM | #12 | |
Brigadier General
2070
Rep 4,365
Posts
Drives: '07 Z4 Coupe, '21 X3, '16 GMC
Join Date: Aug 2007
Location: Iowa
|
Quote:
***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
2016 GMC Sierra SLT Z71 Premium Plus 4x4 2017 Harley StreetGlide • Denim Black • V&H Tune 2021 BMW x30i • Phytonic Blue Metallic • Fully loaded |
|
Appreciate
0
|
Bookmarks |
|
|