#1   Report Post  
Alfonso
 
Posts: n/a
Default Cannot save changes

I am trying to work with some spreadsheets located in another PC of our local
network, which has Windows 98. I´ve got Windows XP Professional. In fact, the
files are located in a folder which has no restrictions to me.

Since I installed some critical updates I have been unable to modify any of
these spreadsheets as Excel tells me it is imposible to save the changes, and
also to work with the temporal file it has created and save it with other
name than the original. As I said, I have total control over the files in
that folder so I can create and delete files, read them but not modify them
now.

I have tried reinstalling Excel 97, upgrading it with Office 97 Service Pack
2b, upgrading it to Excel 2000... but no way to solve this problem. On the
other hand, we have not made any changes to this folder´s access rights.

Any suggestions on why this is happening?
Best regards and happy new year to all,
Alfonso
  #2   Report Post  
Jim Rech
 
Posts: n/a
Default

This is sometimes a virus checker issue. Excel saves the file with a
temporary name and then tries to rename it to the real name. But if a virus
checker has the file open Excel is prevented from renaming.

--
Jim Rech
Excel MVP
"Alfonso" wrote in message
...
|I am trying to work with some spreadsheets located in another PC of our
local
| network, which has Windows 98. I´ve got Windows XP Professional. In fact,
the
| files are located in a folder which has no restrictions to me.
|
| Since I installed some critical updates I have been unable to modify any
of
| these spreadsheets as Excel tells me it is imposible to save the changes,
and
| also to work with the temporal file it has created and save it with other
| name than the original. As I said, I have total control over the files in
| that folder so I can create and delete files, read them but not modify
them
| now.
|
| I have tried reinstalling Excel 97, upgrading it with Office 97 Service
Pack
| 2b, upgrading it to Excel 2000... but no way to solve this problem. On the
| other hand, we have not made any changes to this folder´s access rights.
|
| Any suggestions on why this is happening?
| Best regards and happy new year to all,
| Alfonso


  #3   Report Post  
Alfonso
 
Posts: n/a
Default

Ok, I´ll try uninstalling the antivirus software in both the server and the
client and I´ll tell you.

I still think it may be an issue related with the user rights. If I run
Ne****ch in the host machine to see who has accessed a file in it, it says
the Guest user has opened the spreadsheet and not the user name the client
machine has been given in the start of its session. Strange !!

Any idea?
Best regards,
Alfonso


"Jim Rech" wrote:

This is sometimes a virus checker issue. Excel saves the file with a
temporary name and then tries to rename it to the real name. But if a virus
checker has the file open Excel is prevented from renaming.

--
Jim Rech
Excel MVP
"Alfonso" wrote in message
...
|I am trying to work with some spreadsheets located in another PC of our
local
| network, which has Windows 98. I´ve got Windows XP Professional. In fact,
the
| files are located in a folder which has no restrictions to me.
|
| Since I installed some critical updates I have been unable to modify any
of
| these spreadsheets as Excel tells me it is imposible to save the changes,
and
| also to work with the temporal file it has created and save it with other
| name than the original. As I said, I have total control over the files in
| that folder so I can create and delete files, read them but not modify
them
| now.
|
| I have tried reinstalling Excel 97, upgrading it with Office 97 Service
Pack
| 2b, upgrading it to Excel 2000... but no way to solve this problem. On the
| other hand, we have not made any changes to this folder´s access rights.
|
| Any suggestions on why this is happening?
| Best regards and happy new year to all,
| Alfonso



  #4   Report Post  
Jim Rech
 
Posts: n/a
Default

I still think it may be an issue related with the user rights

While this is the classic virus checker scenario I suppose if delete or
rename rights were missing it would look the same.

--
Jim Rech
Excel MVP
"Alfonso" wrote in message
...
| Ok, I´ll try uninstalling the antivirus software in both the server and
the
| client and I´ll tell you.
|
| I still think it may be an issue related with the user rights. If I run
| Ne****ch in the host machine to see who has accessed a file in it, it says
| the Guest user has opened the spreadsheet and not the user name the client
| machine has been given in the start of its session. Strange !!
|
| Any idea?
| Best regards,
| Alfonso


  #5   Report Post  
Alfonso
 
Posts: n/a
Default

That´s the point in this question. The problem is the machine that hosts the
files is using Windows 98 and there you can only set the rest of the computer
to have read-only or complete access. In this case, the folder is configured
so that anyone has complete access to the files inside. But whenever I check
if the troublesome PC is accesing the files inside this folder, I can see
it´s the guest user who is accesing the files instead of the user that
started the seesionin that machine. Strange, isn´t it?

Maybe i´ll try deactivating the guest user in that machine, as it had to be.

Best regards,
Alfonso

"Jim Rech" escribió:

I still think it may be an issue related with the user rights


While this is the classic virus checker scenario I suppose if delete or
rename rights were missing it would look the same.

--
Jim Rech
Excel MVP
"Alfonso" wrote in message
...
| Ok, I´ll try uninstalling the antivirus software in both the server and
the
| client and I´ll tell you.
|
| I still think it may be an issue related with the user rights. If I run
| Ne****ch in the host machine to see who has accessed a file in it, it says
| the Guest user has opened the spreadsheet and not the user name the client
| machine has been given in the start of its session. Strange !!
|
| Any idea?
| Best regards,
| Alfonso



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 2002 crashing during "Save As" action. Andy T Excel Discussion (Misc queries) 1 January 4th 05 11:34 PM
Save External Link Values Stephane Excel Discussion (Misc queries) 0 January 3rd 05 11:01 AM
Save & Save As features in file menu of Excel Blue Excel Discussion (Misc queries) 9 December 27th 04 08:49 PM
Missing "Save" and "Save As" functions EMSchon Excel Discussion (Misc queries) 2 December 27th 04 08:01 PM
Excel crashing on save as Roundy Excel Discussion (Misc queries) 1 December 10th 04 10:45 PM


All times are GMT +1. The time now is 10:31 PM.

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

About Us

"It's about Microsoft Excel"