View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default two related workfiles

Where are you storing and opening files?

If you have files stored in your XLSTART folder, all will open when you start
Excel.

Move them out to another location..........except for any customized templates
like Book.xlt or Sheet.xlt or Personal.xls

Also all files in ToolsOptionsGeneral "At start up open all files in"

Delete any path from that dialog box.


Gord

On Fri, 7 Mar 2008 09:10:01 -0800, Hank wrote:

Hi Gord,

I searched for xlw file, but can't find it, I tried to move all speadsheets
to a new blank and save it as regular file, but it still open another related
workbook when I open new file. It is annoying...

Don't know how to get rid of it.

Thanks
Hank

"Gord Dibben" wrote:

Sounds like the two files were saved as a "workspace"

Make sure each workbook is saved and closed independently.

Look for *.xlw and delete it.

The two files will not be deleted.


Gord Dibben MS Excel MVP

On Thu, 6 Mar 2008 09:30:04 -0800, Hank wrote:

Hi, I have two Excel work files related, whenever I open one it will
automatically open another one, I wonder how to turn this feature off. It's
annoying. My version is MS office 2002 SP3

Thanks so much,

Hank