Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Protect a range of cells remotely from another file
I have a number of individual files and equal number of people who have
access to each of their own file. I have access to all their files and data. They enter information every month and it gets summarized into my spreadsheet. Once they enter their data and after I look at it, I don't want them to change it again. How do I do it without having to go to individual files and protecting the specific range of cells? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Protect a range of cells remotely from another file
Can you copy your summary sheet after you have viewed it and then 'paste
special'...'values' and copy right over top of itself? That way you will then have only the values and not the linked data. You would of course want to perhaps 'save as' that sheet and rename it if you wanted to retain snap shots in time of the data without blowing away the linked data from your original summary sheet. "Vish" wrote: I have a number of individual files and equal number of people who have access to each of their own file. I have access to all their files and data. They enter information every month and it gets summarized into my spreadsheet. Once they enter their data and after I look at it, I don't want them to change it again. How do I do it without having to go to individual files and protecting the specific range of cells? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Protect a range of cells remotely from another file
Well my intention actually is to prevent them from making any more changes. I
need to keep the links as they are being used check for proof. "tim m" wrote: Can you copy your summary sheet after you have viewed it and then 'paste special'...'values' and copy right over top of itself? That way you will then have only the values and not the linked data. You would of course want to perhaps 'save as' that sheet and rename it if you wanted to retain snap shots in time of the data without blowing away the linked data from your original summary sheet. "Vish" wrote: I have a number of individual files and equal number of people who have access to each of their own file. I have access to all their files and data. They enter information every month and it gets summarized into my spreadsheet. Once they enter their data and after I look at it, I don't want them to change it again. How do I do it without having to go to individual files and protecting the specific range of cells? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calculating only non-empty cells... | Excel Worksheet Functions | |||
Copy/Paste how to avoid the copy of formula cells w/o calc values | Excel Discussion (Misc queries) | |||
Select Range of Cells | Excel Discussion (Misc queries) | |||
Counting empty cells within a range of cells | New Users to Excel | |||
Counting empty cells within a range of cells | New Users to Excel |