PC Review


Reply
Thread Tools Rate Thread

Cannot open more than one Excel file

 
 
=?Utf-8?B?Um9nZXJzICYgQ29tcGFueQ==?=
Guest
Posts: n/a
 
      18th Jun 2007
I can open an existing excel file with no problem. However, if I try to
open another excel file while that first is still open, the first excel file
ends up "pasting" some type of link to the file I tried to open into a cell.
Not a true
link, but it pastes the path (C:\mydocuments...etc.). In other words, I
cannot open more than one excel document at a time.

Any help?

 
Reply With Quote
 
 
 
 
Gord Dibben
Guest
Posts: n/a
 
      18th Jun 2007
Where does it paste the path?

In a cell or?


Gord Dibben MS Excel MVP

On Mon, 18 Jun 2007 10:41:01 -0700, Rogers & Company
<(E-Mail Removed)> wrote:

>I can open an existing excel file with no problem. However, if I try to
>open another excel file while that first is still open, the first excel file
>ends up "pasting" some type of link to the file I tried to open into a cell.
> Not a true
>link, but it pastes the path (C:\mydocuments...etc.). In other words, I
>cannot open more than one excel document at a time.
>
>Any help?


 
Reply With Quote
 
=?Utf-8?B?Um9nZXJzICYgQ29tcGFueQ==?=
Guest
Posts: n/a
 
      18th Jun 2007
Yes, it paste the path in the cell of the current open Excel workbook. The
cell I was last in.

I'll be in the workbook. If I go to "file, open.." it will open the other
excel workbook, but if I open it through explorer (as I usually do), it will
paste the path to the cell in teh worksheet.

This is Office/Excel 2007, and only started happening after I made a change
in the registry by adding some sort of "%1". That solved all sorts of excel
problems
(like not opening at all, error messages, etc.), and now it works fine -
except this one issue.

"Gord Dibben" wrote:

> Where does it paste the path?
>
> In a cell or?
>
>
> Gord Dibben MS Excel MVP
>
> On Mon, 18 Jun 2007 10:41:01 -0700, Rogers & Company
> <(E-Mail Removed)> wrote:
>
> >I can open an existing excel file with no problem. However, if I try to
> >open another excel file while that first is still open, the first excel file
> >ends up "pasting" some type of link to the file I tried to open into a cell.
> > Not a true
> >link, but it pastes the path (C:\mydocuments...etc.). In other words, I
> >cannot open more than one excel document at a time.
> >
> >Any help?

>
>

 
Reply With Quote
 
Gord Dibben
Guest
Posts: n/a
 
      18th Jun 2007
I don't have Excel 2007 so cannot test.

Perhaps one of the 2007 users will jump in.

Exactly where did you make the Registry change upon advice from where?


Gord

On Mon, 18 Jun 2007 13:19:01 -0700, Rogers & Company
<(E-Mail Removed)> wrote:

>Yes, it paste the path in the cell of the current open Excel workbook. The
>cell I was last in.
>
>I'll be in the workbook. If I go to "file, open.." it will open the other
>excel workbook, but if I open it through explorer (as I usually do), it will
>paste the path to the cell in teh worksheet.
>
>This is Office/Excel 2007, and only started happening after I made a change
>in the registry by adding some sort of "%1". That solved all sorts of excel
>problems
>(like not opening at all, error messages, etc.), and now it works fine -
>except this one issue.
>
>"Gord Dibben" wrote:
>
>> Where does it paste the path?
>>
>> In a cell or?
>>
>>
>> Gord Dibben MS Excel MVP
>>
>> On Mon, 18 Jun 2007 10:41:01 -0700, Rogers & Company
>> <(E-Mail Removed)> wrote:
>>
>> >I can open an existing excel file with no problem. However, if I try to
>> >open another excel file while that first is still open, the first excel file
>> >ends up "pasting" some type of link to the file I tried to open into a cell.
>> > Not a true
>> >link, but it pastes the path (C:\mydocuments...etc.). In other words, I
>> >cannot open more than one excel document at a time.
>> >
>> >Any help?

>>
>>


 
Reply With Quote
 
=?Utf-8?B?Um9nZXJzICYgQ29tcGFueQ==?=
Guest
Posts: n/a
 
      18th Jun 2007
I followed these instructions from microsoft (which do not seem exclusive to
Excel 2007). Once I did this, everyting worked, except I got the pasting
problem when opening new files. It could this did not cause the problem, but
it's the only thing it happened after applying this fix. Could be it existed
already but I couldn't see it...after all, I wasn't able to open existing
excel files until I did this fix.

http://support.microsoft.com/kb/207574


"Gord Dibben" wrote:

> I don't have Excel 2007 so cannot test.
>
> Perhaps one of the 2007 users will jump in.
>
> Exactly where did you make the Registry change upon advice from where?
>
>
> Gord
>
> On Mon, 18 Jun 2007 13:19:01 -0700, Rogers & Company
> <(E-Mail Removed)> wrote:
>
> >Yes, it paste the path in the cell of the current open Excel workbook. The
> >cell I was last in.
> >
> >I'll be in the workbook. If I go to "file, open.." it will open the other
> >excel workbook, but if I open it through explorer (as I usually do), it will
> >paste the path to the cell in teh worksheet.
> >
> >This is Office/Excel 2007, and only started happening after I made a change
> >in the registry by adding some sort of "%1". That solved all sorts of excel
> >problems
> >(like not opening at all, error messages, etc.), and now it works fine -
> >except this one issue.
> >
> >"Gord Dibben" wrote:
> >
> >> Where does it paste the path?
> >>
> >> In a cell or?
> >>
> >>
> >> Gord Dibben MS Excel MVP
> >>
> >> On Mon, 18 Jun 2007 10:41:01 -0700, Rogers & Company
> >> <(E-Mail Removed)> wrote:
> >>
> >> >I can open an existing excel file with no problem. However, if I try to
> >> >open another excel file while that first is still open, the first excel file
> >> >ends up "pasting" some type of link to the file I tried to open into a cell.
> >> > Not a true
> >> >link, but it pastes the path (C:\mydocuments...etc.). In other words, I
> >> >cannot open more than one excel document at a time.
> >> >
> >> >Any help?
> >>
> >>

>
>

 
Reply With Quote
 
Gord Dibben
Guest
Posts: n/a
 
      19th Jun 2007
Those instructions include 2002, 2003 and 2007 and are one of a couple of
standard fixes for the "file not found" message.

I prefer to leave the registry alone and change the command line in Tools>Folder
Options>File Types or just re-register Excel.

Close Excel first and On the Windows Taskbar

1) Start>Run "excel.exe /unregserver"(no quotes)>OK.
2) Start>Run "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 Start>Run "C:\yourpath\excel.exe /regserver"(no quotes)>OK.

But......the pathname in a cell is strange behaviour no matter how you open a
workbook.


Gord

On Mon, 18 Jun 2007 15:37:00 -0700, Rogers & Company
<(E-Mail Removed)> wrote:

>I followed these instructions from microsoft (which do not seem exclusive to
>Excel 2007). Once I did this, everyting worked, except I got the pasting
>problem when opening new files. It could this did not cause the problem, but
>it's the only thing it happened after applying this fix. Could be it existed
>already but I couldn't see it...after all, I wasn't able to open existing
>excel files until I did this fix.
>
>http://support.microsoft.com/kb/207574
>
>
>"Gord Dibben" wrote:
>
>> I don't have Excel 2007 so cannot test.
>>
>> Perhaps one of the 2007 users will jump in.
>>
>> Exactly where did you make the Registry change upon advice from where?
>>
>>
>> Gord
>>
>> On Mon, 18 Jun 2007 13:19:01 -0700, Rogers & Company
>> <(E-Mail Removed)> wrote:
>>
>> >Yes, it paste the path in the cell of the current open Excel workbook. The
>> >cell I was last in.
>> >
>> >I'll be in the workbook. If I go to "file, open.." it will open the other
>> >excel workbook, but if I open it through explorer (as I usually do), it will
>> >paste the path to the cell in teh worksheet.
>> >
>> >This is Office/Excel 2007, and only started happening after I made a change
>> >in the registry by adding some sort of "%1". That solved all sorts of excel
>> >problems
>> >(like not opening at all, error messages, etc.), and now it works fine -
>> >except this one issue.
>> >
>> >"Gord Dibben" wrote:
>> >
>> >> Where does it paste the path?
>> >>
>> >> In a cell or?
>> >>
>> >>
>> >> Gord Dibben MS Excel MVP
>> >>
>> >> On Mon, 18 Jun 2007 10:41:01 -0700, Rogers & Company
>> >> <(E-Mail Removed)> wrote:
>> >>
>> >> >I can open an existing excel file with no problem. However, if I try to
>> >> >open another excel file while that first is still open, the first excel file
>> >> >ends up "pasting" some type of link to the file I tried to open into a cell.
>> >> > Not a true
>> >> >link, but it pastes the path (C:\mydocuments...etc.). In other words, I
>> >> >cannot open more than one excel document at a time.
>> >> >
>> >> >Any help?
>> >>
>> >>

>>
>>


 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
EXCEL wont open from Explorer, must open EXCEL then find file =?Utf-8?B?d2x1ZHdpY2s=?= Microsoft Excel Misc 4 7th Sep 2006 08:06 PM
In Excel - Use Windows Explorer instead of File Open to open file =?Utf-8?B?S3ltWQ==?= Microsoft Excel Misc 1 5th Aug 2006 09:59 PM
Unable to open an excel file on desktop, must open excel first =?Utf-8?B?U21pdHQ=?= Microsoft Excel Misc 1 11th Jan 2006 09:20 PM
My excel program wont open. I can open an exciting excel file =?Utf-8?B?Z2VvcmdlMTM2MA==?= Microsoft Access 1 12th Jun 2005 11:14 PM
Excel 2003 Workbooks.Open with CorruptLoad=xlRepairFile fails on Excel 5.0/95 file due to Chart, with Error 1004 Method 'Open' of object 'Workbooks' failed Frank Jones Microsoft Excel Programming 2 15th Jun 2004 03:21 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 01:18 AM.