Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 12
Default Excel 2007 Modify Permissions Problem.

What does Modify actually do?
When I was using Excel 2003 I was able to save a file in a mapped drive
without any problems. Now I'm using Excel 2007 and in order for me to save
the file ".xls" I need to have Modify permissions turned on.

We are trying to keep people, myself included, from having too much power
when it comes to what can be done to files or sub-directories.

I only need Modify for one file in the top directory. If Im given Modify in
the top folder, I end up having modified in all of the sub-folders as well. I
tried giving myself Modify permissions just to the file but that doesn't work
because when I try and save the file it says "Access denied. Contact your
administrator" and a tmp file gets created each and every time I press save
in the mapped directory.

Now I had a real brain storm, I'd create a sub-directory and copy the file
into that directory and give myself Modify permissions for only that
directory, there are no sub-directories in this folder. This does work except
we have around 2000 hyperlinks that all get broken. I turns out that the
first part of the hyperlink path gets changed to each and every link. There
is no way we are going to go in there and fix each link one at a time.

Im using Windows XP Pro w/SP3 and Office 2007 Ultimate.

Boy am I bummed :(

Is there a way to allow me to just make changes just to that file and not be
able to modify any other files or is there a way I can modify all of our
hyperlinks without having to do one at a time? As far as the hyperlinks there
is just one false directory name that needs to be pulled out and this would
fix everything.

  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 12
Default Excel 2007 Modify Permissions Problem.

I forgot to mention my current permissions:
Read & Execute, List Folder Contents, Read, and Write

"engel59" wrote:

What does Modify actually do?
When I was using Excel 2003 I was able to save a file in a mapped drive
without any problems. Now I'm using Excel 2007 and in order for me to save
the file ".xls" I need to have Modify permissions turned on.

We are trying to keep people, myself included, from having too much power
when it comes to what can be done to files or sub-directories.

I only need Modify for one file in the top directory. If Im given Modify in
the top folder, I end up having modified in all of the sub-folders as well. I
tried giving myself Modify permissions just to the file but that doesn't work
because when I try and save the file it says "Access denied. Contact your
administrator" and a tmp file gets created each and every time I press save
in the mapped directory.

Now I had a real brain storm, I'd create a sub-directory and copy the file
into that directory and give myself Modify permissions for only that
directory, there are no sub-directories in this folder. This does work except
we have around 2000 hyperlinks that all get broken. I turns out that the
first part of the hyperlink path gets changed to each and every link. There
is no way we are going to go in there and fix each link one at a time.

Im using Windows XP Pro w/SP3 and Office 2007 Ultimate.

Boy am I bummed :(

Is there a way to allow me to just make changes just to that file and not be
able to modify any other files or is there a way I can modify all of our
hyperlinks without having to do one at a time? As far as the hyperlinks there
is just one false directory name that needs to be pulled out and this would
fix everything.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2007 crashes when I try to modify a data series formula! Mike Charts and Charting in Excel 4 February 14th 08 06:23 PM
Assigning RMS permissions in Excel 2007 havenlad Excel Discussion (Misc queries) 0 January 15th 08 02:44 PM
Modify Custom Toolbars in Excel 2007 pawinterks Excel Discussion (Misc queries) 2 December 8th 06 10:34 PM
Excel Permissions James A Excel Discussion (Misc queries) 1 September 23rd 06 01:49 AM
Problem to modify the size of PlotArea Xavier Charts and Charting in Excel 1 April 24th 06 10:56 PM


All times are GMT +1. The time now is 07:21 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"