Excel 2003 documents open slow or do not open.

I can open Excel 2003, then click the file in the Recent list and/or the File
>> Open route and all opens up instantly without issue. Try to just
double-click the same Excel documents and it could take 30 seconds to 3
minutes to open up Excel and most of the time Excel opens up without opening
the workbook.

I can save an empty workbook and when i try to open the file it reacts the
same way as a workbook full of data.
I have repaired office.
I have completely wiped out the Windows XP user profile and started a new
thinkin it was a corruption in the profile and nothing.
Only thing left that I know would fix this is re-image the computer but I
would rather not have to deal with this in that matter.

Does anybody have any suggestions that I could try? Would be very much
appreciated.

Thanks ahead of time.

If the problem is ONLY when you double-click on a file to open it. the
problem is likely due to DDE. It can be fixed by reinstalling, OR this
workaround.

Go to Control Panel, Folder Options, File Types, scroll down to and
select XLS, click Advanced, select Open entry, click the edit Button.
Now uncheck "Use DDE" and then put your cursor in the Application box,
arrow all the way to the right and put in "%1" (include the quote
marks), IF there is /dde remove it. Then OK you way out. Things should
work quickly again.

TW wrote:

> I can open Excel 2003, then click the file in the Recent list and/or the File
>
>>>Open route and all opens up instantly without issue. Try to just
>
> double-click the same Excel documents and it could take 30 seconds to 3
> minutes to open up Excel and most of the time Excel opens up without opening
> the workbook.
>
> I can save an empty workbook and when i try to open the file it reacts the
> same way as a workbook full of data.
> I have repaired office.
> I have completely wiped out the Windows XP user profile and started a new
> thinkin it was a corruption in the profile and nothing.
> Only thing left that I know would fix this is re-image the computer but I
> would rather not have to deal with this in that matter.
>
> Does anybody have any suggestions that I could try? Would be very much
> appreciated.
>
> Thanks ahead of time.

Bob,
Thanks for the tip. It worked like a charm. It also works on word documents
as well.
ervinta

"Bob I" wrote:

> If the problem is ONLY when you double-click on a file to open it. the
> problem is likely due to DDE. It can be fixed by reinstalling, OR this
> workaround.
>
> Go to Control Panel, Folder Options, File Types, scroll down to and
> select XLS, click Advanced, select Open entry, click the edit Button.
> Now uncheck "Use DDE" and then put your cursor in the Application box,
> arrow all the way to the right and put in "%1" (include the quote
> marks), IF there is /dde remove it. Then OK you way out. Things should
> work quickly again.
>
> TW wrote:
>
> > I can open Excel 2003, then click the file in the Recent list and/or the File
> >
> >>>Open route and all opens up instantly without issue. Try to just
> >
> > double-click the same Excel documents and it could take 30 seconds to 3
> > minutes to open up Excel and most of the time Excel opens up without opening
> > the workbook.
> >
> > I can save an empty workbook and when i try to open the file it reacts the
> > same way as a workbook full of data.
> > I have repaired office.
> > I have completely wiped out the Windows XP user profile and started a new
> > thinkin it was a corruption in the profile and nothing.
> > Only thing left that I know would fix this is re-image the computer but I
> > would rather not have to deal with this in that matter.
> >
> > Does anybody have any suggestions that I could try? Would be very much
> > appreciated.
> >
> > Thanks ahead of time.
>
>

You're welcome, have a great day!

ervinta wrote:

> Bob,
> Thanks for the tip. It worked like a charm. It also works on word documents
> as well.
> ervinta
>
> "Bob I" wrote:
>
>
>>If the problem is ONLY when you double-click on a file to open it. the
>>problem is likely due to DDE. It can be fixed by reinstalling, OR this
>>workaround.
>>
>>Go to Control Panel, Folder Options, File Types, scroll down to and
>>select XLS, click Advanced, select Open entry, click the edit Button.
>>Now uncheck "Use DDE" and then put your cursor in the Application box,
>>arrow all the way to the right and put in "%1" (include the quote
>>marks), IF there is /dde remove it. Then OK you way out. Things should
>>work quickly again.
>>
>>TW wrote:
>>
>>
>>>I can open Excel 2003, then click the file in the Recent list and/or the File
>>>
>>>
>>>>>Open route and all opens up instantly without issue. Try to just
>>>
>>>double-click the same Excel documents and it could take 30 seconds to 3
>>>minutes to open up Excel and most of the time Excel opens up without opening
>>>the workbook.
>>>
>>>I can save an empty workbook and when i try to open the file it reacts the
>>>same way as a workbook full of data.
>>>I have repaired office.
>>>I have completely wiped out the Windows XP user profile and started a new
>>>thinkin it was a corruption in the profile and nothing.
>>>Only thing left that I know would fix this is re-image the computer but I
>>>would rather not have to deal with this in that matter.
>>>
>>>Does anybody have any suggestions that I could try? Would be very much
>>>appreciated.
>>>
>>>Thanks ahead of time.
>>
>>

Hi all,

We've experienced similar problems with a lot of the clients on our network.
Does anyone know what's causing this behaviour in the first place?

The only thing I can think of is an upgrade to our A/V software (Trend
OfficeScan) that happened at or around the same time people started to
experience these issues.

Cheers,

Ross.

"Bob I" wrote:

> You're welcome, have a great day!
>
> ervinta wrote:
>
> > Bob,
> > Thanks for the tip. It worked like a charm. It also works on word documents
> > as well.
> > ervinta
> >
> > "Bob I" wrote:
> >
> >
> >>If the problem is ONLY when you double-click on a file to open it. the
> >>problem is likely due to DDE. It can be fixed by reinstalling, OR this
> >>workaround.
> >>
> >>Go to Control Panel, Folder Options, File Types, scroll down to and
> >>select XLS, click Advanced, select Open entry, click the edit Button.
> >>Now uncheck "Use DDE" and then put your cursor in the Application box,
> >>arrow all the way to the right and put in "%1" (include the quote
> >>marks), IF there is /dde remove it. Then OK you way out. Things should
> >>work quickly again.
> >>
> >>TW wrote:
> >>
> >>
> >>>I can open Excel 2003, then click the file in the Recent list and/or the File
> >>>
> >>>
> >>>>>Open route and all opens up instantly without issue. Try to just
> >>>
> >>>double-click the same Excel documents and it could take 30 seconds to 3
> >>>minutes to open up Excel and most of the time Excel opens up without opening
> >>>the workbook.
> >>>
> >>>I can save an empty workbook and when i try to open the file it reacts the
> >>>same way as a workbook full of data.
> >>>I have repaired office.
> >>>I have completely wiped out the Windows XP user profile and started a new
> >>>thinkin it was a corruption in the profile and nothing.
> >>>Only thing left that I know would fix this is re-image the computer but I
> >>>would rather not have to deal with this in that matter.
> >>>
> >>>Does anybody have any suggestions that I could try? Would be very much
> >>>appreciated.
> >>>
> >>>Thanks ahead of time.
> >>
> >>
>
>

The issue of A-V software "scanning" documents at the time they are
opened has caused nothing but grief for Office users for years. Disable
any form of Officescan, Office Plug-in, or other attachment scanning
addin as they provide NO additional security AND interfere with the
application woring properly.

Ross wrote:

> Hi all,
>
> We've experienced similar problems with a lot of the clients on our network.
> Does anyone know what's causing this behaviour in the first place?
>
> The only thing I can think of is an upgrade to our A/V software (Trend
> OfficeScan) that happened at or around the same time people started to
> experience these issues.
>
> Cheers,
>
> Ross.
>
> "Bob I" wrote:
>
>
>>You're welcome, have a great day!
>>
>>ervinta wrote:
>>
>>
>>>Bob,
>>>Thanks for the tip. It worked like a charm. It also works on word documents
>>>as well.
>>>ervinta
>>>
>>>"Bob I" wrote:
>>>
>>>
>>>
>>>>If the problem is ONLY when you double-click on a file to open it. the
>>>>problem is likely due to DDE. It can be fixed by reinstalling, OR this
>>>>workaround.
>>>>
>>>>Go to Control Panel, Folder Options, File Types, scroll down to and
>>>>select XLS, click Advanced, select Open entry, click the edit Button.
>>>>Now uncheck "Use DDE" and then put your cursor in the Application box,
>>>>arrow all the way to the right and put in "%1" (include the quote
>>>>marks), IF there is /dde remove it. Then OK you way out. Things should
>>>>work quickly again.
>>>>
>>>>TW wrote:
>>>>
>>>>
>>>>
>>>>>I can open Excel 2003, then click the file in the Recent list and/or the File
>>>>>
>>>>>
>>>>>
>>>>>>>Open route and all opens up instantly without issue. Try to just
>>>>>
>>>>>double-click the same Excel documents and it could take 30 seconds to 3
>>>>>minutes to open up Excel and most of the time Excel opens up without opening
>>>>>the workbook.
>>>>>
>>>>>I can save an empty workbook and when i try to open the file it reacts the
>>>>>same way as a workbook full of data.
>>>>>I have repaired office.
>>>>>I have completely wiped out the Windows XP user profile and started a new
>>>>>thinkin it was a corruption in the profile and nothing.
>>>>>Only thing left that I know would fix this is re-image the computer but I
>>>>>would rather not have to deal with this in that matter.
>>>>>
>>>>>Does anybody have any suggestions that I could try? Would be very much
>>>>>appreciated.
>>>>>
>>>>>Thanks ahead of time.
>>>>
>>>>
>>

Everywhere on the Internet people are suggesting disabling DDE, which
has it's own share of problems (opening multiple copies of excel, error
messages pertaining to personal.xls).

There's a simpler solution.

In excel, hold alt and press f11 to open the VBA editor, and remove any
VBA code in the Personal.xls project.

Voila, no more 60 second delay when opening the first excel document.


--
friction81
------------------------------------------------------------------------
friction81's Profile: http://forums.techarena.in/member.php?u=52829
View this thread: http://forums.techarena.in/showthread.php?t=749154

http://forums.techarena.in