ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Setting up and Configuration of Excel (https://www.excelbanter.com/setting-up-configuration-excel/)
-   -   Save a Copy? (https://www.excelbanter.com/setting-up-configuration-excel/149869-save-copy.html)

George W. Barrowcliff

Save a Copy?
 
A while ago I upgraded my disk drive from 40 to 120 GB using the Acronis
True Image product. The only issues I experienced is I was forced to
reinstall both Adobe V8 Professional and also Microsoft Streets and Trips.

One other issue was also created and I cannot find why.

When I click on Save, I always get a window that pops up with the message:

"The file 'BalanceSheet.XLS' may have been changed by another user since you
last saved it. In that case, what do you want to do?" and I have the
option of Saving a Copy or Overwrite Changes.

I know that no other user has this open, I have no application that has it
open and no changes have been made to the original since I opened the spread
sheet.

The only other thing that might be important is the spreadsheet is on a
networked drive, assigned to Z: on my system.

What is Excel looking at that causes this message?

TIA, GWB



Gord Dibben

Save a Copy?
 
What is the exact error message?

If same as below have a look at this KB article.

"The file may have been changed..." error when you save workbook to network
server in Excel 2002 and 2003

http://support.microsoft.com/default.aspx?kbid=324491

Myrna Larson also reported that she got this error when opening a workspace
(*.xlw) file.

Opening the workbooks individually solved the problem.


Gord Dibben Excel MVP

On Wed, 11 Jul 2007 14:10:56 -0700, "George W. Barrowcliff"
wrote:

A while ago I upgraded my disk drive from 40 to 120 GB using the Acronis
True Image product. The only issues I experienced is I was forced to
reinstall both Adobe V8 Professional and also Microsoft Streets and Trips.

One other issue was also created and I cannot find why.

When I click on Save, I always get a window that pops up with the message:

"The file 'BalanceSheet.XLS' may have been changed by another user since you
last saved it. In that case, what do you want to do?" and I have the
option of Saving a Copy or Overwrite Changes.

I know that no other user has this open, I have no application that has it
open and no changes have been made to the original since I opened the spread
sheet.

The only other thing that might be important is the spreadsheet is on a
networked drive, assigned to Z: on my system.

What is Excel looking at that causes this message?

TIA, GWB



George W. Barrowcliff

Save a Copy?
 
Thanks, editing the registry with a value of 2 as indicated in the KB
article worked for me.

GWB

"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
What is the exact error message?

If same as below have a look at this KB article.

"The file may have been changed..." error when you save workbook to
network
server in Excel 2002 and 2003

http://support.microsoft.com/default.aspx?kbid=324491

Myrna Larson also reported that she got this error when opening a
workspace
(*.xlw) file.

Opening the workbooks individually solved the problem.


Gord Dibben Excel MVP

On Wed, 11 Jul 2007 14:10:56 -0700, "George W. Barrowcliff"
wrote:

A while ago I upgraded my disk drive from 40 to 120 GB using the Acronis
True Image product. The only issues I experienced is I was forced to
reinstall both Adobe V8 Professional and also Microsoft Streets and Trips.

One other issue was also created and I cannot find why.

When I click on Save, I always get a window that pops up with the message:

"The file 'BalanceSheet.XLS' may have been changed by another user since
you
last saved it. In that case, what do you want to do?" and I have the
option of Saving a Copy or Overwrite Changes.

I know that no other user has this open, I have no application that has it
open and no changes have been made to the original since I opened the
spread
sheet.

The only other thing that might be important is the spreadsheet is on a
networked drive, assigned to Z: on my system.

What is Excel looking at that causes this message?

TIA, GWB






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

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