ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Cannot save changes (https://www.excelbanter.com/excel-discussion-misc-queries/2958-cannot-save-changes.html)

Alfonso

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

Jim Rech

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



Alfonso

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




Jim Rech

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



Alfonso

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





All times are GMT +1. The time now is 01:34 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com