opening files error

R

Ria

For some reason, none of my Excel 2003 files will open when I double-click
them from a folder or desktop shortcut - the only way I can open a file is to
start Excel, click open and browse for the file I want.

As a side note, I was recently attempting to get my workbooks to open in
separate windows as opposed to multiple files open under the same heading -
i.e. I wanted each file to have it's own toolabar, etc. After reading several
discussion posts, I tried clicking Tools>Options>View>checking "Windows in
Taskbar" and Tools>Options>General>checking "Ignore other Applications". I
also went to Window>Arrange and tried checking horizontally or vertically,
although this did not give the result I wanted, since it simply put the
workbooks horizontally or vertically in one window instead of distinct
windows. However, after closing down Excel and reopening it, the files are
now in distinct windows, but this problem of opening files has arisen - the
above changes are the only ones I've made recently, so I was wondering if any
of those could be the problem or if there is another solution.
 
G

Gord Dibben

You want each workbook to open in its own instance of Excel when you
double-click on a filename?

Start>Run

"c:\program files\microsoft office\office11\excel.exe" /unregserver

Then open Excel and Tools>Options>View "Windows in Taskbar"

BUT...........the only way to get unique Toolbars for each instance is to
create them when a particular workbook opens.

Each instance of Excel uses the same Excel11.xlb file which is the file
where Toolbar and Menu customizations are stored.

So..........if the only reason you want separate instances of Excel is to
get unique Toolbar and menu customizations, you are going in the wrong
direction.


Gord Dibben MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top