When I double-click on an Excel file from Windows Explorer (without Excel
running), a pop-up informs me that I cannot have two files with the same name
open at the same time. However, if I click OK, the window goes away, the file
opens and everything seems ok. If I then close that file but leave Excel
running, I can then reopen the same file with no pop-up, even if I open it
from Windows Explorer. I can also open any Excel file without the pop-up if I
first start Excel. Now, for any Excel file that I open, no matter how I open
it, when I go to close it (without having changed anything in the file) it
always asks me if I want to save the changes.

Hmmm . . . I cannot figure this one out.

Please help if you can.

Thx, Jim H.
--
Jim H.

Try the usual fixes for this.

ToolsOptionsGeneral Uncheck "Ignore Other Applications"

If no joy with that................

Close Excel first and On the Windows Taskbar

1) StartRun "excel.exe /unregserver"(no quotes)OK.
2) StartRun "excel.exe /regserver"(no quotes)OK.

See the space between exe and /regserver

You might have to designate a full path to excel.exe.

In that case StartRun "C:\yourpath\excel.exe" /regserver(quotes
required)OK.


Gord Dibben MS Excel MVP

On Tue, 5 Aug 2008 09:54:01 -0700, Jim H.
wrote:

When I double-click on an Excel file from Windows Explorer (without Excel
running), a pop-up informs me that I cannot have two files with the same name
open at the same time. However, if I click OK, the window goes away, the file
opens and everything seems ok. If I then close that file but leave Excel
running, I can then reopen the same file with no pop-up, even if I open it
from Windows Explorer. I can also open any Excel file without the pop-up if I
first start Excel. Now, for any Excel file that I open, no matter how I open
it, when I go to close it (without having changed anything in the file) it
always asks me if I want to save the changes.

Hmmm . . . I cannot figure this one out.

Please help if you can.

Thx, Jim H.

Thanks, Gord; I did all three operations you suggested. The middle one,
(unregserver-regserver) eliminated the problem of the pop-up window telling
me I couldn't have two files of the same name open at the same time. However,
the problem of the pop-up asking me if I want to save changes when I've made
no changes remains.

What do do???
--
Jim H.


"Gord Dibben" wrote:

Try the usual fixes for this.

ToolsOptionsGeneral Uncheck "Ignore Other Applications"

If no joy with that................

Close Excel first and On the Windows Taskbar

1) StartRun "excel.exe /unregserver"(no quotes)OK.
2) StartRun "excel.exe /regserver"(no quotes)OK.

See the space between exe and /regserver

You might have to designate a full path to excel.exe.

In that case StartRun "C:\yourpath\excel.exe" /regserver(quotes
required)OK.


Gord Dibben MS Excel MVP

On Tue, 5 Aug 2008 09:54:01 -0700, Jim H.
wrote:

When I double-click on an Excel file from Windows Explorer (without Excel
running), a pop-up informs me that I cannot have two files with the same name
open at the same time. However, if I click OK, the window goes away, the file
opens and everything seems ok. If I then close that file but leave Excel
running, I can then reopen the same file with no pop-up, even if I open it
from Windows Explorer. I can also open any Excel file without the pop-up if I
first start Excel. Now, for any Excel file that I open, no matter how I open
it, when I go to close it (without having changed anything in the file) it
always asks me if I want to save the changes.

Hmmm . . . I cannot figure this one out.

Please help if you can.

Thx, Jim H.

Do you have any volatile formulas in the workbook like NOW(), TODAY()
INDIRECT, OFFSET etc. If you do than that is what happens.

--


Regards,


Peo Sjoblom

"Jim H." wrote in message
...
Thanks, Gord; I did all three operations you suggested. The middle one,
(unregserver-regserver) eliminated the problem of the pop-up window
telling
me I couldn't have two files of the same name open at the same time.
However,
the problem of the pop-up asking me if I want to save changes when I've
made
no changes remains.

What do do???
--
Jim H.


"Gord Dibben" wrote:

Try the usual fixes for this.

ToolsOptionsGeneral Uncheck "Ignore Other Applications"

If no joy with that................

Close Excel first and On the Windows Taskbar

1) StartRun "excel.exe /unregserver"(no quotes)OK.
2) StartRun "excel.exe /regserver"(no quotes)OK.

See the space between exe and /regserver

You might have to designate a full path to excel.exe.

In that case StartRun "C:\yourpath\excel.exe" /regserver(quotes
required)OK.


Gord Dibben MS Excel MVP

On Tue, 5 Aug 2008 09:54:01 -0700, Jim H.

wrote:

When I double-click on an Excel file from Windows Explorer (without
Excel
running), a pop-up informs me that I cannot have two files with the same
name
open at the same time. However, if I click OK, the window goes away, the
file
opens and everything seems ok. If I then close that file but leave Excel
running, I can then reopen the same file with no pop-up, even if I open
it
from Windows Explorer. I can also open any Excel file without the pop-up
if I
first start Excel. Now, for any Excel file that I open, no matter how I
open
it, when I go to close it (without having changed anything in the file)
it
always asks me if I want to save the changes.

Hmmm . . . I cannot figure this one out.

Please help if you can.

Thx, Jim H.

Thanks Peo.

I missed that part of the post.


Gord

On Tue, 5 Aug 2008 12:43:50 -0700, "Peo Sjoblom"
wrote:

Do you have any volatile formulas in the workbook like NOW(), TODAY()
INDIRECT, OFFSET etc. If you do than that is what happens.

Peo,

No, I don't do fancy stuff. I'm just a General Contractor that uses Excel to
make invoices for my customers. My most complex formula is, for example,
"sum(E2:E15)". I do, however, use the current date thingy in my headers so I
will know when a printed invoice was spit out of my printer.
--
Jim H.


"Peo Sjoblom" wrote:

Do you have any volatile formulas in the workbook like NOW(), TODAY()
INDIRECT, OFFSET etc. If you do than that is what happens.

--


Regards,


Peo Sjoblom

"Jim H." wrote in message
...
Thanks, Gord; I did all three operations you suggested. The middle one,
(unregserver-regserver) eliminated the problem of the pop-up window
telling
me I couldn't have two files of the same name open at the same time.
However,
the problem of the pop-up asking me if I want to save changes when I've
made
no changes remains.

What do do???
--
Jim H.


"Gord Dibben" wrote:

Try the usual fixes for this.

ToolsOptionsGeneral Uncheck "Ignore Other Applications"

If no joy with that................

Close Excel first and On the Windows Taskbar

1) StartRun "excel.exe /unregserver"(no quotes)OK.
2) StartRun "excel.exe /regserver"(no quotes)OK.

See the space between exe and /regserver

You might have to designate a full path to excel.exe.

In that case StartRun "C:\yourpath\excel.exe" /regserver(quotes
required)OK.


Gord Dibben MS Excel MVP

On Tue, 5 Aug 2008 09:54:01 -0700, Jim H.

wrote:

When I double-click on an Excel file from Windows Explorer (without
Excel
running), a pop-up informs me that I cannot have two files with the same
name
open at the same time. However, if I click OK, the window goes away, the
file
opens and everything seems ok. If I then close that file but leave Excel
running, I can then reopen the same file with no pop-up, even if I open
it
from Windows Explorer. I can also open any Excel file without the pop-up
if I
first start Excel. Now, for any Excel file that I open, no matter how I
open
it, when I go to close it (without having changed anything in the file)
it
always asks me if I want to save the changes.

Hmmm . . . I cannot figure this one out.

Please help if you can.

Thx, Jim H.

OOPS, I lied.

I do use a "=TODAY()" thing in a cell. I didn't remember looking that up to
use it in a cell. I thought I had used a date thing in the header.

I guess "TODAY" really changes from session to session. That is, if I save
and close the file and then reopen it immediately and then try to close again
without making any changes, it asks me if I want to save the changes.
However, if I save the file without closing and then wait for a few minutes
and then close the file, it just saves it without asking me anything.

What's the difference?

--
Jim H.


"Jim H." wrote:

Peo,

No, I don't do fancy stuff. I'm just a General Contractor that uses Excel to
make invoices for my customers. My most complex formula is, for example,
"sum(E2:E15)". I do, however, use the current date thingy in my headers so I
will know when a printed invoice was spit out of my printer.
--
Jim H.


"Peo Sjoblom" wrote:

Do you have any volatile formulas in the workbook like NOW(), TODAY()
INDIRECT, OFFSET etc. If you do than that is what happens.

--


Regards,


Peo Sjoblom

"Jim H." wrote in message
...
Thanks, Gord; I did all three operations you suggested. The middle one,
(unregserver-regserver) eliminated the problem of the pop-up window
telling
me I couldn't have two files of the same name open at the same time.
However,
the problem of the pop-up asking me if I want to save changes when I've
made
no changes remains.

What do do???
--
Jim H.


"Gord Dibben" wrote:

Try the usual fixes for this.

ToolsOptionsGeneral Uncheck "Ignore Other Applications"

If no joy with that................

Close Excel first and On the Windows Taskbar

1) StartRun "excel.exe /unregserver"(no quotes)OK.
2) StartRun "excel.exe /regserver"(no quotes)OK.

See the space between exe and /regserver

You might have to designate a full path to excel.exe.

In that case StartRun "C:\yourpath\excel.exe" /regserver(quotes
required)OK.


Gord Dibben MS Excel MVP

On Tue, 5 Aug 2008 09:54:01 -0700, Jim H.

wrote:

When I double-click on an Excel file from Windows Explorer (without
Excel
running), a pop-up informs me that I cannot have two files with the same
name
open at the same time. However, if I click OK, the window goes away, the
file
opens and everything seems ok. If I then close that file but leave Excel
running, I can then reopen the same file with no pop-up, even if I open
it
from Windows Explorer. I can also open any Excel file without the pop-up
if I
first start Excel. Now, for any Excel file that I open, no matter how I
open
it, when I go to close it (without having changed anything in the file)
it
always asks me if I want to save the changes.

Hmmm . . . I cannot figure this one out.

Please help if you can.

Thx, Jim H.