View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Peo Sjoblom[_2_] Peo Sjoblom[_2_] is offline
external usenet poster
 
Posts: 964
Default Curious interaction W/Win Exp.

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.