#1   Report Post  
John Taylor
 
Posts: n/a
Default File Reservation

Hi to all,

I'm using Excel 97 SR-2 with Win XP SP2 on a home computer that's linked to
another computer, and experiencing an intermittent problem for which I would
like a solution.

Sometimes, when I double click an Excel file I get the message:

"File Reservation

'filename.xls' is being modified by

Username

Open as read-only, or choose Notify to be alerted when it is available"

There are three buttons - Read Only, Notify, and Cancel.

If I click 'Cancel' then double click the file again it opens normally.

When it happens the second computer is not running Excel.

It can occur both with files containing macros and those without macros. If
it occurs with files containing macros I get the macro warning prior to the
'File Reservation' message.

Any hints as to the cause, and a possible remedy, will be more than welcome.

Cheers,

John


  #2   Report Post  
Peter Jausovec
 
Posts: n/a
Default

Hi John,

Try hitting ctrl-alt-delete to see if there is any hidden instance of excel
left running.

--
http://blog.jausovec.net


"John Taylor" je napisal:

Hi to all,

I'm using Excel 97 SR-2 with Win XP SP2 on a home computer that's linked to
another computer, and experiencing an intermittent problem for which I would
like a solution.

Sometimes, when I double click an Excel file I get the message:

"File Reservation

'filename.xls' is being modified by

Username

Open as read-only, or choose Notify to be alerted when it is available"

There are three buttons - Read Only, Notify, and Cancel.

If I click 'Cancel' then double click the file again it opens normally.

When it happens the second computer is not running Excel.

It can occur both with files containing macros and those without macros. If
it occurs with files containing macros I get the macro warning prior to the
'File Reservation' message.

Any hints as to the cause, and a possible remedy, will be more than welcome.

Cheers,

John



  #3   Report Post  
Dave Peterson
 
Posts: n/a
Default

maybe...

http://www.contextures.com/xlfaqApp.html#ReadOnly

From Debra Dalgleish's site.

John Taylor wrote:

Hi to all,

I'm using Excel 97 SR-2 with Win XP SP2 on a home computer that's linked to
another computer, and experiencing an intermittent problem for which I would
like a solution.

Sometimes, when I double click an Excel file I get the message:

"File Reservation

'filename.xls' is being modified by

Username

Open as read-only, or choose Notify to be alerted when it is available"

There are three buttons - Read Only, Notify, and Cancel.

If I click 'Cancel' then double click the file again it opens normally.

When it happens the second computer is not running Excel.

It can occur both with files containing macros and those without macros. If
it occurs with files containing macros I get the macro warning prior to the
'File Reservation' message.

Any hints as to the cause, and a possible remedy, will be more than welcome.

Cheers,

John


--

Dave Peterson
  #4   Report Post  
John Taylor
 
Posts: n/a
Default

Peter and Dave,

Thanks for your suggestions.

Unfortunately I had already tried both those options, but without success.
It appears to be some other odd, well hidden, cause.

Cheers,

John

"Dave Peterson" wrote in message
...
maybe...

http://www.contextures.com/xlfaqApp.html#ReadOnly

From Debra Dalgleish's site.

John Taylor wrote:

Hi to all,

I'm using Excel 97 SR-2 with Win XP SP2 on a home computer that's linked
to
another computer, and experiencing an intermittent problem for which I
would
like a solution.

Sometimes, when I double click an Excel file I get the message:

"File Reservation

'filename.xls' is being modified by

Username

Open as read-only, or choose Notify to be alerted when it is available"

There are three buttons - Read Only, Notify, and Cancel.

If I click 'Cancel' then double click the file again it opens normally.

When it happens the second computer is not running Excel.

It can occur both with files containing macros and those without macros.
If
it occurs with files containing macros I get the macro warning prior to
the
'File Reservation' message.

Any hints as to the cause, and a possible remedy, will be more than
welcome.

Cheers,

John


--

Dave Peterson



  #5   Report Post  
Dave Peterson
 
Posts: n/a
Default

Did you try rebooting the "server" pc? (The one that holds that workbook.)

In fact, have you rebooted both pcs?

(I don't know if it'll help, but it might....)

John Taylor wrote:

Peter and Dave,

Thanks for your suggestions.

Unfortunately I had already tried both those options, but without success.
It appears to be some other odd, well hidden, cause.

Cheers,

John

"Dave Peterson" wrote in message
...
maybe...

http://www.contextures.com/xlfaqApp.html#ReadOnly

From Debra Dalgleish's site.

John Taylor wrote:

Hi to all,

I'm using Excel 97 SR-2 with Win XP SP2 on a home computer that's linked
to
another computer, and experiencing an intermittent problem for which I
would
like a solution.

Sometimes, when I double click an Excel file I get the message:

"File Reservation

'filename.xls' is being modified by

Username

Open as read-only, or choose Notify to be alerted when it is available"

There are three buttons - Read Only, Notify, and Cancel.

If I click 'Cancel' then double click the file again it opens normally.

When it happens the second computer is not running Excel.

It can occur both with files containing macros and those without macros.
If
it occurs with files containing macros I get the macro warning prior to
the
'File Reservation' message.

Any hints as to the cause, and a possible remedy, will be more than
welcome.

Cheers,

John


--

Dave Peterson


--

Dave Peterson


  #6   Report Post  
John Taylor
 
Posts: n/a
Default

Dave,

Certainly did - have rebooted both PCs, but it didn't help.

The really odd, and frustrating, thing about this problem is that it appears
to be intermittent and also not restricted to any particular workbooks.

Once again, thanks for taking the time to offer a suggestion.

Cheers,

John

"Dave Peterson" wrote in message
...
Did you try rebooting the "server" pc? (The one that holds that
workbook.)

In fact, have you rebooted both pcs?

(I don't know if it'll help, but it might....)

John Taylor wrote:

Peter and Dave,

Thanks for your suggestions.

Unfortunately I had already tried both those options, but without
success.
It appears to be some other odd, well hidden, cause.

Cheers,

John

"Dave Peterson" wrote in message
...
maybe...

http://www.contextures.com/xlfaqApp.html#ReadOnly

From Debra Dalgleish's site.

John Taylor wrote:

Hi to all,

I'm using Excel 97 SR-2 with Win XP SP2 on a home computer that's
linked
to
another computer, and experiencing an intermittent problem for which I
would
like a solution.

Sometimes, when I double click an Excel file I get the message:

"File Reservation

'filename.xls' is being modified by

Username

Open as read-only, or choose Notify to be alerted when it is
available"

There are three buttons - Read Only, Notify, and Cancel.

If I click 'Cancel' then double click the file again it opens
normally.

When it happens the second computer is not running Excel.

It can occur both with files containing macros and those without
macros.
If
it occurs with files containing macros I get the macro warning prior
to
the
'File Reservation' message.

Any hints as to the cause, and a possible remedy, will be more than
welcome.

Cheers,

John

--

Dave Peterson


--

Dave Peterson



  #7   Report Post  
Dave Peterson
 
Posts: n/a
Default

Sorry it didn't help.

Maybe someone else can jump in with a suggestion that'll work.

John Taylor wrote:

Dave,

Certainly did - have rebooted both PCs, but it didn't help.

The really odd, and frustrating, thing about this problem is that it appears
to be intermittent and also not restricted to any particular workbooks.

Once again, thanks for taking the time to offer a suggestion.

Cheers,

John

"Dave Peterson" wrote in message
...
Did you try rebooting the "server" pc? (The one that holds that
workbook.)

In fact, have you rebooted both pcs?

(I don't know if it'll help, but it might....)

John Taylor wrote:

Peter and Dave,

Thanks for your suggestions.

Unfortunately I had already tried both those options, but without
success.
It appears to be some other odd, well hidden, cause.

Cheers,

John

"Dave Peterson" wrote in message
...
maybe...

http://www.contextures.com/xlfaqApp.html#ReadOnly

From Debra Dalgleish's site.

John Taylor wrote:

Hi to all,

I'm using Excel 97 SR-2 with Win XP SP2 on a home computer that's
linked
to
another computer, and experiencing an intermittent problem for which I
would
like a solution.

Sometimes, when I double click an Excel file I get the message:

"File Reservation

'filename.xls' is being modified by

Username

Open as read-only, or choose Notify to be alerted when it is
available"

There are three buttons - Read Only, Notify, and Cancel.

If I click 'Cancel' then double click the file again it opens
normally.

When it happens the second computer is not running Excel.

It can occur both with files containing macros and those without
macros.
If
it occurs with files containing macros I get the macro warning prior
to
the
'File Reservation' message.

Any hints as to the cause, and a possible remedy, will be more than
welcome.

Cheers,

John

--

Dave Peterson


--

Dave Peterson


--

Dave Peterson
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
Opening a file with code without a set file name jenkinspat Excel Discussion (Misc queries) 1 March 3rd 05 03:40 PM
Locating a file in excel with a partial file name. Audra Excel Discussion (Misc queries) 2 February 19th 05 08:52 PM
Locating a file in excel with a partial file name. Audra Excel Discussion (Misc queries) 0 February 19th 05 02:03 PM
Locating a file in excel with a partial file name. Audra Excel Discussion (Misc queries) 0 February 19th 05 02:01 PM
Read Text File into Excel Using VBA Willie T Excel Discussion (Misc queries) 13 January 8th 05 12:37 AM


All times are GMT +1. The time now is 04:10 AM.

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"