(2007) Excel macro blocks Outlook???

[C. Moya]

Why does a long running macro in Excel 2007 block Outlook???
(No, the macro doesn't access Outlook in any way. It does use ADO to access
a database).
I've noticed similar things on several occassions... where one Office 2007
App will block another (for no reason).

God I hate Office 2007.

 

[Roady [MVP]]

Blocks Outlook in what way? From starting up?

 

[C. Moya]

Blocks Outlook in what way? From starting up?

No, from working period. Outlook is loaded up. It freezes (neither its main
window nor any open message windows respond). I expect Excel to be frozen
while the macro runs (the macro runs against a database and fills some
cells.... it takes some time), but not Outlook!!!

I haven't tested to see if other Office apps are affected too. In any case,
this is a real downer. Office 2003 and prior didn't do this.

 

[Roady [MVP]]

Hmm, interesting. Do you have another machine available to see if you can
repro the issue? If so; you might want to raise a support incident with
Microsoft. Support is free the first 90 days and basically always free if
they confirm it as a bug.

--
Robert Sparnaaij [MVP-Outlook]
Coauthor, Configuring Microsoft Outlook 2003

 

[Patrick Schmid [MVP]]

Could it just be that the macro forces Excel to take 100% of the CPU and
hence nothing is left over for Outlook to run with? Have you watched the
CPU consumption of the Excel and Outlook processes during the execution
of the macro? One way to determine whether it's a CPU issue, is to
reduce the Excel process to the lowest priority possible while the macro
is running and to see whether Outlook is usable then.

Patrick Schmid [OneNote MVP]
--------------
http://pschmid.net
***
Outlook 2007 Performance Update: http://pschmid.net/blog/2007/04/13/105
Office 2007 RTM Issues: http://pschmid.net/blog/2006/11/13/80
***
Customize Office 2007: http://pschmid.net/office2007/customize
RibbonCustomizer Add-In: http://pschmid.net/office2007/ribboncustomizer
OneNote 2007: http://pschmid.net/office2007/onenote
***
Subscribe to my Office 2007 blog: http://pschmid.net/blog/feed

 

[C. Moya]

All other programs respond fine. The CPU isn't really hit hard because the
bottleneck is the vpn connection to the database. I did (quick and dirty)
try an empty Do-Loop in Excel to see if the same thing happened. It didn't.
Outlook responded just fine (eventhough, ironically, CPU was at 100%).

I will try to experiment some more and isolate the problem...

But, I do know for a fact that I've seen this at other times.... although
I've never paid enough mind to make a note of exactly when. For instance,
Access will also block other Office apps. It seems that under some
circumstances, Office 2007 apps are very sensitive to each other. I'll try
to experiment some more

P.S.
(this issue is now a big deal for us.... I can't have my employees not use
Outlook just because they're pulling info the database into Excel.... it's
bad enough that Excel's MDI crippled window already blocks access to their
other open workbooks).

--
-C. Moya
www.cmoya.com

Could it just be that the macro forces Excel to take 100% of the CPU and
hence nothing is left over for Outlook to run with? Have you watched the
CPU consumption of the Excel and Outlook processes during the execution of
the macro? One way to determine whether it's a CPU issue, is to reduce the
Excel process to the lowest priority possible while the macro is running
and to see whether Outlook is usable then.

Patrick Schmid [OneNote MVP]
--------------
http://pschmid.net
***
Outlook 2007 Performance Update: http://pschmid.net/blog/2007/04/13/105
Office 2007 RTM Issues: http://pschmid.net/blog/2006/11/13/80
***
Customize Office 2007: http://pschmid.net/office2007/customize
RibbonCustomizer Add-In: http://pschmid.net/office2007/ribboncustomizer
OneNote 2007: http://pschmid.net/office2007/onenote
***
Subscribe to my Office 2007 blog: http://pschmid.net/blog/feed

in
message news:[email protected]...

No, from working period. Outlook is loaded up. It freezes (neither its
main
window nor any open message windows respond). I expect Excel to be frozen
while the macro runs (the macro runs against a database and fills some
cells.... it takes some time), but not Outlook!!!

I haven't tested to see if other Office apps are affected too. In any
case,
this is a real downer. Office 2003 and prior didn't do this.

 

[Roady [MVP]]

So if you are trashing the VPN connection with Excel queries how do you
think Outlook can maintain its connection to the Exchange server or am I
missing something in your setup here?

--
Robert Sparnaaij [MVP-Outlook]
Coauthor, Configuring Microsoft Outlook 2003


-----

All other programs respond fine. The CPU isn't really hit hard because the
bottleneck is the vpn connection to the database. I did (quick and dirty)
try an empty Do-Loop in Excel to see if the same thing happened. It
didn't. Outlook responded just fine (eventhough, ironically, CPU was at
100%).

I will try to experiment some more and isolate the problem...

But, I do know for a fact that I've seen this at other times.... although
I've never paid enough mind to make a note of exactly when. For instance,
Access will also block other Office apps. It seems that under some
circumstances, Office 2007 apps are very sensitive to each other. I'll try
to experiment some more

P.S.
(this issue is now a big deal for us.... I can't have my employees not use
Outlook just because they're pulling info the database into Excel.... it's
bad enough that Excel's MDI crippled window already blocks access to their
other open workbooks).

--
-C. Moya
www.cmoya.com

Could it just be that the macro forces Excel to take 100% of the CPU and
hence nothing is left over for Outlook to run with? Have you watched the
CPU consumption of the Excel and Outlook processes during the execution
of the macro? One way to determine whether it's a CPU issue, is to reduce
the Excel process to the lowest priority possible while the macro is
running and to see whether Outlook is usable then.

Patrick Schmid [OneNote MVP]
--------------
http://pschmid.net
***
Outlook 2007 Performance Update: http://pschmid.net/blog/2007/04/13/105
Office 2007 RTM Issues: http://pschmid.net/blog/2006/11/13/80
***
Customize Office 2007: http://pschmid.net/office2007/customize
RibbonCustomizer Add-In: http://pschmid.net/office2007/ribboncustomizer
OneNote 2007: http://pschmid.net/office2007/onenote
***
Subscribe to my Office 2007 blog: http://pschmid.net/blog/feed

in
message Blocks Outlook in what way? From starting up?

--
Robert Sparnaaij [MVP-Outlook]
Coauthor, Configuring Microsoft Outlook 2003

No, from working period. Outlook is loaded up. It freezes (neither its
main
window nor any open message windows respond). I expect Excel to be
frozen
while the macro runs (the macro runs against a database and fills some
cells.... it takes some time), but not Outlook!!!

I haven't tested to see if other Office apps are affected too. In any
case,
this is a real downer. Office 2003 and prior didn't do this.

 

[Patrick Schmid [MVP]]

Are you running the Outlook Performance Update already?

Patrick Schmid [OneNote MVP]
--------------
http://pschmid.net
***
Outlook 2007 Performance Update: http://pschmid.net/blog/2007/04/13/105
Office 2007 RTM Issues: http://pschmid.net/blog/2006/11/13/80
***
Customize Office 2007: http://pschmid.net/office2007/customize
RibbonCustomizer Add-In: http://pschmid.net/office2007/ribboncustomizer
OneNote 2007: http://pschmid.net/office2007/onenote
***
Subscribe to my Office 2007 blog: http://pschmid.net/blog/feed

All other programs respond fine. The CPU isn't really hit hard because the
bottleneck is the vpn connection to the database. I did (quick and dirty)
try an empty Do-Loop in Excel to see if the same thing happened. It didn't.
Outlook responded just fine (eventhough, ironically, CPU was at 100%).

I will try to experiment some more and isolate the problem...

But, I do know for a fact that I've seen this at other times.... although
I've never paid enough mind to make a note of exactly when. For instance,
Access will also block other Office apps. It seems that under some
circumstances, Office 2007 apps are very sensitive to each other. I'll try
to experiment some more

P.S.
(this issue is now a big deal for us.... I can't have my employees not use
Outlook just because they're pulling info the database into Excel.... it's
bad enough that Excel's MDI crippled window already blocks access to their
other open workbooks).

--
-C. Moya
www.cmoya.com

Could it just be that the macro forces Excel to take 100% of the CPU and
hence nothing is left over for Outlook to run with? Have you watched the
CPU consumption of the Excel and Outlook processes during the execution of
the macro? One way to determine whether it's a CPU issue, is to reduce the
Excel process to the lowest priority possible while the macro is running
and to see whether Outlook is usable then.

Patrick Schmid [OneNote MVP]
--------------
http://pschmid.net
***
Outlook 2007 Performance Update: http://pschmid.net/blog/2007/04/13/105
Office 2007 RTM Issues: http://pschmid.net/blog/2006/11/13/80
***
Customize Office 2007: http://pschmid.net/office2007/customize
RibbonCustomizer Add-In: http://pschmid.net/office2007/ribboncustomizer
OneNote 2007: http://pschmid.net/office2007/onenote
***
Subscribe to my Office 2007 blog: http://pschmid.net/blog/feed

in
message Blocks Outlook in what way? From starting up?

--
Robert Sparnaaij [MVP-Outlook]
Coauthor, Configuring Microsoft Outlook 2003

No, from working period. Outlook is loaded up. It freezes (neither its
main
window nor any open message windows respond). I expect Excel to be frozen
while the macro runs (the macro runs against a database and fills some
cells.... it takes some time), but not Outlook!!!

I haven't tested to see if other Office apps are affected too. In any
case,
this is a real downer. Office 2003 and prior didn't do this.

 

[C. Moya]

So if you are trashing the VPN connection with Excel queries how do you
think Outlook can maintain its connection to the Exchange server or am I
missing something in your setup here?

I'm talking about a UI freeze here. Outlook does its Exchange connection
stuff in a background thread. The UI is hardly ever affected. I trash the
VPN connection regularly... and Outlook never chokes or ceases to respond.

 

[C. Moya]

Are you running the Outlook Performance Update already?

Patrick Schmid [OneNote MVP]

I have no idea what that is. Was it part of Windows Update? I've had no
problems with Outlook 2007 otherwise... performance-wise anyway-- other than
this Excel problem.
I'll research this update.

 

[Patrick Schmid [MVP]]

See the link in my signature. It addresses a serious performance issues
with PSTs/OSTs that are 1 GB or bigger, but I would personally recommend
everyone to install it.

Patrick Schmid [OneNote MVP]
--------------
http://pschmid.net
***
Outlook 2007 Performance Update: http://pschmid.net/blog/2007/04/13/105
Office 2007 RTM Issues: http://pschmid.net/blog/2006/11/13/80
***
Customize Office 2007: http://pschmid.net/office2007/customize
RibbonCustomizer Add-In: http://pschmid.net/office2007/ribboncustomizer
OneNote 2007: http://pschmid.net/office2007/onenote
***
Subscribe to my Office 2007 blog: http://pschmid.net/blog/feed

Are you running the Outlook Performance Update already?

Patrick Schmid [OneNote MVP]

I have no idea what that is. Was it part of Windows Update? I've had no
problems with Outlook 2007 otherwise... performance-wise anyway-- other than
this Excel problem.
I'll research this update.

 

[C. Moya]

I have confirmed this issue on at least two machines. And it is easy to
reproduce.

Create a VBA macro with a simple Do-Loop that will tie up Excel.
Example:
Public Sub TestPerf
Do
'do nothing
Loop
End Sub

Start the macro. While it is running, go to your Outlook window. Create a
New message. Close the message. See Outlook hang.

This problem isn't limited to just "macros." Anytime another Office app
begins a time-consuming process it seems to block other Office apps in some
way or another.

--
-C. Moya
www.cmoya.com

So if you are trashing the VPN connection with Excel queries how do you
think Outlook can maintain its connection to the Exchange server or am I
missing something in your setup here?

--
Robert Sparnaaij [MVP-Outlook]
Coauthor, Configuring Microsoft Outlook 2003


-----

All other programs respond fine. The CPU isn't really hit hard because
the bottleneck is the vpn connection to the database. I did (quick and
dirty) try an empty Do-Loop in Excel to see if the same thing happened.
It didn't. Outlook responded just fine (eventhough, ironically, CPU was
at 100%).

I will try to experiment some more and isolate the problem...

But, I do know for a fact that I've seen this at other times.... although
I've never paid enough mind to make a note of exactly when. For instance,
Access will also block other Office apps. It seems that under some
circumstances, Office 2007 apps are very sensitive to each other. I'll
try to experiment some more

P.S.
(this issue is now a big deal for us.... I can't have my employees not
use Outlook just because they're pulling info the database into Excel....
it's bad enough that Excel's MDI crippled window already blocks access to
their other open workbooks).

--
-C. Moya
www.cmoya.com

Could it just be that the macro forces Excel to take 100% of the CPU and
hence nothing is left over for Outlook to run with? Have you watched the
CPU consumption of the Excel and Outlook processes during the execution
of the macro? One way to determine whether it's a CPU issue, is to
reduce the Excel process to the lowest priority possible while the macro
is running and to see whether Outlook is usable then.

Patrick Schmid [OneNote MVP]
--------------
http://pschmid.net
***
Outlook 2007 Performance Update: http://pschmid.net/blog/2007/04/13/105
Office 2007 RTM Issues: http://pschmid.net/blog/2006/11/13/80
***
Customize Office 2007: http://pschmid.net/office2007/customize
RibbonCustomizer Add-In: http://pschmid.net/office2007/ribboncustomizer
OneNote 2007: http://pschmid.net/office2007/onenote
***
Subscribe to my Office 2007 blog: http://pschmid.net/blog/feed


"Roady [MVP]" <newsgroups_DELETE_@_DELETE_sparnaaij_NO_._SPAM_net>
wrote in
message Blocks Outlook in what way? From starting up?

--
Robert Sparnaaij [MVP-Outlook]
Coauthor, Configuring Microsoft Outlook 2003

No, from working period. Outlook is loaded up. It freezes (neither its
main
window nor any open message windows respond). I expect Excel to be
frozen
while the macro runs (the macro runs against a database and fills some
cells.... it takes some time), but not Outlook!!!

I haven't tested to see if other Office apps are affected too. In any
case,
this is a real downer. Office 2003 and prior didn't do this.

 

[Patrick Schmid [MVP]]

I don't have a repro here. Sure Outlook was considerably slowed down due
to Excel being a CPU hog, but it remained usable and it didn't hang.
Note that I have the performance update installed.

Patrick Schmid [OneNote MVP]
--------------
http://pschmid.net
***
Outlook 2007 Performance Update: http://pschmid.net/blog/2007/04/13/105
Office 2007 RTM Issues: http://pschmid.net/blog/2006/11/13/80
***
Customize Office 2007: http://pschmid.net/office2007/customize
RibbonCustomizer Add-In: http://pschmid.net/office2007/ribboncustomizer
OneNote 2007: http://pschmid.net/office2007/onenote
***
Subscribe to my Office 2007 blog: http://pschmid.net/blog/feed

I have confirmed this issue on at least two machines. And it is easy to
reproduce.

Create a VBA macro with a simple Do-Loop that will tie up Excel.
Example:
Public Sub TestPerf
Do
'do nothing
Loop
End Sub

Start the macro. While it is running, go to your Outlook window. Create a
New message. Close the message. See Outlook hang.

This problem isn't limited to just "macros." Anytime another Office app
begins a time-consuming process it seems to block other Office apps in some
way or another.

--
-C. Moya
www.cmoya.com

So if you are trashing the VPN connection with Excel queries how do you
think Outlook can maintain its connection to the Exchange server or am I
missing something in your setup here?

--
Robert Sparnaaij [MVP-Outlook]
Coauthor, Configuring Microsoft Outlook 2003
http://www.howto-outlook.com/
Outlook FAQ, HowTo, Downloads, Add-Ins and more

-----

All other programs respond fine. The CPU isn't really hit hard because
the bottleneck is the vpn connection to the database. I did (quick and
dirty) try an empty Do-Loop in Excel to see if the same thing happened.
It didn't. Outlook responded just fine (eventhough, ironically, CPU was
at 100%).

I will try to experiment some more and isolate the problem...

But, I do know for a fact that I've seen this at other times.... although
I've never paid enough mind to make a note of exactly when. For instance,
Access will also block other Office apps. It seems that under some
circumstances, Office 2007 apps are very sensitive to each other. I'll
try to experiment some more

P.S.
(this issue is now a big deal for us.... I can't have my employees not
use Outlook just because they're pulling info the database into Excel....
it's bad enough that Excel's MDI crippled window already blocks access to
their other open workbooks).

--
-C. Moya
www.cmoya.com
Could it just be that the macro forces Excel to take 100% of the CPU and
hence nothing is left over for Outlook to run with? Have you watched the
CPU consumption of the Excel and Outlook processes during the execution
of the macro? One way to determine whether it's a CPU issue, is to
reduce the Excel process to the lowest priority possible while the macro
is running and to see whether Outlook is usable then.

Patrick Schmid [OneNote MVP]
--------------
http://pschmid.net
***
Outlook 2007 Performance Update: http://pschmid.net/blog/2007/04/13/105
Office 2007 RTM Issues: http://pschmid.net/blog/2006/11/13/80
***
Customize Office 2007: http://pschmid.net/office2007/customize
RibbonCustomizer Add-In: http://pschmid.net/office2007/ribboncustomizer
OneNote 2007: http://pschmid.net/office2007/onenote
***
Subscribe to my Office 2007 blog: http://pschmid.net/blog/feed


"Roady [MVP]" <newsgroups_DELETE_@_DELETE_sparnaaij_NO_._SPAM_net>
wrote in
message Blocks Outlook in what way? From starting up?

--
Robert Sparnaaij [MVP-Outlook]
Coauthor, Configuring Microsoft Outlook 2003

No, from working period. Outlook is loaded up. It freezes (neither its
main
window nor any open message windows respond). I expect Excel to be
frozen
while the macro runs (the macro runs against a database and fills some
cells.... it takes some time), but not Outlook!!!

I haven't tested to see if other Office apps are affected too. In any
case,
this is a real downer. Office 2003 and prior didn't do this.

 

[C. Moya]

Were you able to start a new message and close it?

Anyway, I will install the performance update tonight and see if it solves
the problem.

--
-C. Moya
www.cmoya.com

I don't have a repro here. Sure Outlook was considerably slowed down due to
Excel being a CPU hog, but it remained usable and it didn't hang. Note that
I have the performance update installed.

Patrick Schmid [OneNote MVP]
--------------
http://pschmid.net
***
Outlook 2007 Performance Update: http://pschmid.net/blog/2007/04/13/105
Office 2007 RTM Issues: http://pschmid.net/blog/2006/11/13/80
***
Customize Office 2007: http://pschmid.net/office2007/customize
RibbonCustomizer Add-In: http://pschmid.net/office2007/ribboncustomizer
OneNote 2007: http://pschmid.net/office2007/onenote
***
Subscribe to my Office 2007 blog: http://pschmid.net/blog/feed

I have confirmed this issue on at least two machines. And it is easy to
reproduce.

Create a VBA macro with a simple Do-Loop that will tie up Excel.
Example:
Public Sub TestPerf
Do
'do nothing
Loop
End Sub

Start the macro. While it is running, go to your Outlook window. Create a
New message. Close the message. See Outlook hang.

This problem isn't limited to just "macros." Anytime another Office app
begins a time-consuming process it seems to block other Office apps in
some
way or another.

--
-C. Moya
www.cmoya.com
in
message news:[email protected]...

So if you are trashing the VPN connection with Excel queries how do you
think Outlook can maintain its connection to the Exchange server or am
I
missing something in your setup here?

--
Robert Sparnaaij [MVP-Outlook]
Coauthor, Configuring Microsoft Outlook 2003
http://www.howto-outlook.com/
Outlook FAQ, HowTo, Downloads, Add-Ins and more

-----
All other programs respond fine. The CPU isn't really hit hard because
the bottleneck is the vpn connection to the database. I did (quick and
dirty) try an empty Do-Loop in Excel to see if the same thing
happened.
It didn't. Outlook responded just fine (eventhough, ironically, CPU
was
at 100%).

I will try to experiment some more and isolate the problem...

But, I do know for a fact that I've seen this at other times....
although
I've never paid enough mind to make a note of exactly when. For
instance,
Access will also block other Office apps. It seems that under some
circumstances, Office 2007 apps are very sensitive to each other. I'll
try to experiment some more

P.S.
(this issue is now a big deal for us.... I can't have my employees not
use Outlook just because they're pulling info the database into
Excel....
it's bad enough that Excel's MDI crippled window already blocks access
to
their other open workbooks).

--
-C. Moya
www.cmoya.com
Could it just be that the macro forces Excel to take 100% of the CPU
and
hence nothing is left over for Outlook to run with? Have you watched
the
CPU consumption of the Excel and Outlook processes during the
execution
of the macro? One way to determine whether it's a CPU issue, is to
reduce the Excel process to the lowest priority possible while the
macro
is running and to see whether Outlook is usable then.

Patrick Schmid [OneNote MVP]
--------------
http://pschmid.net
***
Outlook 2007 Performance Update:
http://pschmid.net/blog/2007/04/13/105
Office 2007 RTM Issues: http://pschmid.net/blog/2006/11/13/80
***
Customize Office 2007: http://pschmid.net/office2007/customize
RibbonCustomizer Add-In:
http://pschmid.net/office2007/ribboncustomizer
OneNote 2007: http://pschmid.net/office2007/onenote
***
Subscribe to my Office 2007 blog: http://pschmid.net/blog/feed


"Roady [MVP]" <newsgroups_DELETE_@_DELETE_sparnaaij_NO_._SPAM_net>
wrote in
message Blocks Outlook in what way? From starting up?

--
Robert Sparnaaij [MVP-Outlook]
Coauthor, Configuring Microsoft Outlook 2003

No, from working period. Outlook is loaded up. It freezes (neither
its
main
window nor any open message windows respond). I expect Excel to be
frozen
while the macro runs (the macro runs against a database and fills
some
cells.... it takes some time), but not Outlook!!!

I haven't tested to see if other Office apps are affected too. In
any
case,
this is a real downer. Office 2003 and prior didn't do this.

 

[Patrick Schmid [MVP]]

Yes, I was. Note though that I am not using Exchange. I only use IMAP.

Were you able to start a new message and close it?

Anyway, I will install the performance update tonight and see if it solves
the problem.

--
-C. Moya
www.cmoya.com

I don't have a repro here. Sure Outlook was considerably slowed down due to
Excel being a CPU hog, but it remained usable and it didn't hang. Note that
I have the performance update installed.

Patrick Schmid [OneNote MVP]
--------------
http://pschmid.net
***
Outlook 2007 Performance Update: http://pschmid.net/blog/2007/04/13/105
Office 2007 RTM Issues: http://pschmid.net/blog/2006/11/13/80
***
Customize Office 2007: http://pschmid.net/office2007/customize
RibbonCustomizer Add-In: http://pschmid.net/office2007/ribboncustomizer
OneNote 2007: http://pschmid.net/office2007/onenote
***
Subscribe to my Office 2007 blog: http://pschmid.net/blog/feed

I have confirmed this issue on at least two machines. And it is easy to
reproduce.

Create a VBA macro with a simple Do-Loop that will tie up Excel.
Example:
Public Sub TestPerf
Do
'do nothing
Loop
End Sub

Start the macro. While it is running, go to your Outlook window. Create a
New message. Close the message. See Outlook hang.

This problem isn't limited to just "macros." Anytime another Office app
begins a time-consuming process it seems to block other Office apps in
some
way or another.

--
-C. Moya
www.cmoya.com
in
message So if you are trashing the VPN connection with Excel queries how do you
think Outlook can maintain its connection to the Exchange server or am
I
missing something in your setup here?

--
Robert Sparnaaij [MVP-Outlook]
Coauthor, Configuring Microsoft Outlook 2003
http://www.howto-outlook.com/
Outlook FAQ, HowTo, Downloads, Add-Ins and more

-----
All other programs respond fine. The CPU isn't really hit hard because
the bottleneck is the vpn connection to the database. I did (quick and
dirty) try an empty Do-Loop in Excel to see if the same thing
happened.
It didn't. Outlook responded just fine (eventhough, ironically, CPU
was
at 100%).

I will try to experiment some more and isolate the problem...

But, I do know for a fact that I've seen this at other times....
although
I've never paid enough mind to make a note of exactly when. For
instance,
Access will also block other Office apps. It seems that under some
circumstances, Office 2007 apps are very sensitive to each other. I'll
try to experiment some more

P.S.
(this issue is now a big deal for us.... I can't have my employees not
use Outlook just because they're pulling info the database into
Excel....
it's bad enough that Excel's MDI crippled window already blocks access
to
their other open workbooks).

--
-C. Moya
www.cmoya.com
Could it just be that the macro forces Excel to take 100% of the CPU
and
hence nothing is left over for Outlook to run with? Have you watched
the
CPU consumption of the Excel and Outlook processes during the
execution
of the macro? One way to determine whether it's a CPU issue, is to
reduce the Excel process to the lowest priority possible while the
macro
is running and to see whether Outlook is usable then.

Patrick Schmid [OneNote MVP]
--------------
http://pschmid.net
***
Outlook 2007 Performance Update:
http://pschmid.net/blog/2007/04/13/105
Office 2007 RTM Issues: http://pschmid.net/blog/2006/11/13/80
***
Customize Office 2007: http://pschmid.net/office2007/customize
RibbonCustomizer Add-In:
http://pschmid.net/office2007/ribboncustomizer
OneNote 2007: http://pschmid.net/office2007/onenote
***
Subscribe to my Office 2007 blog: http://pschmid.net/blog/feed


"Roady [MVP]" <newsgroups_DELETE_@_DELETE_sparnaaij_NO_._SPAM_net>
wrote in
message Blocks Outlook in what way? From starting up?

--
Robert Sparnaaij [MVP-Outlook]
Coauthor, Configuring Microsoft Outlook 2003

No, from working period. Outlook is loaded up. It freezes (neither
its
main
window nor any open message windows respond). I expect Excel to be
frozen
while the macro runs (the macro runs against a database and fills
some
cells.... it takes some time), but not Outlook!!!

I haven't tested to see if other Office apps are affected too. In
any
case,
this is a real downer. Office 2003 and prior didn't do this.

 

[Ken Slovak - [MVP - Outlook]]

I tested this against an Exchange server (Exchange 2003 SP2, LAN connection
to my Exchange server).

As an added bonus I tested it when that computer was running a full
anti-virus scan on the hard drive.

Things were slower in Outlook with the Excel process using 99% of the CPU
certainly, but there was no hang in Outlook and I was able to open a new
mail item, type in it and then close it with no problems.

I have the Outlook speed-up hot fix installed on that Outlook 2007 setup.
The test was run on a Windows XP SP2 machine. I didn't test on any of my
Vista setups.

 

[C. Moya]

The update does resolve the problem. Thank you for pointing me to it.

--
-C. Moya
www.cmoya.com

See the link in my signature. It addresses a serious performance issues
with PSTs/OSTs that are 1 GB or bigger, but I would personally recommend
everyone to install it.

Patrick Schmid [OneNote MVP]
--------------
http://pschmid.net
***
Outlook 2007 Performance Update: http://pschmid.net/blog/2007/04/13/105
Office 2007 RTM Issues: http://pschmid.net/blog/2006/11/13/80
***
Customize Office 2007: http://pschmid.net/office2007/customize
RibbonCustomizer Add-In: http://pschmid.net/office2007/ribboncustomizer
OneNote 2007: http://pschmid.net/office2007/onenote
***
Subscribe to my Office 2007 blog: http://pschmid.net/blog/feed

Are you running the Outlook Performance Update already?

Patrick Schmid [OneNote MVP]

I have no idea what that is. Was it part of Windows Update? I've had no
problems with Outlook 2007 otherwise... performance-wise anyway-- other
than
this Excel problem.
I'll research this update.

 

[Patrick Schmid [MVP]]

Do you have your virus scanner integrated with Outlook or email in
general? If yes, switch that off, as it only costs performance but
doesn't add any protection.
If you disconnect the VPN and then try to repro it, can you still repro
it?
How about if you leave the VPN connected, but open Outlook in safe mode
(start, run, "outlook /a"). Still a repro?
If you open Outlook in safe mode and disable your virus scanner (all of
it, not just the Outlook integration), still a repro?

Patrick Schmid [OneNote MVP]
--------------
http://pschmid.net
***
Outlook 2007 Performance Update: http://pschmid.net/blog/2007/04/13/105
Office 2007 RTM Issues: http://pschmid.net/blog/2006/11/13/80
***
Customize Office 2007: http://pschmid.net/office2007/customize
RibbonCustomizer Add-In: http://pschmid.net/office2007/ribboncustomizer
OneNote 2007: http://pschmid.net/office2007/onenote
***
Subscribe to my Office 2007 blog: http://pschmid.net/blog/feed

The update does resolve the problem. Thank you for pointing me to it.

--
-C. Moya
www.cmoya.com

See the link in my signature. It addresses a serious performance issues
with PSTs/OSTs that are 1 GB or bigger, but I would personally recommend
everyone to install it.

Patrick Schmid [OneNote MVP]
--------------
http://pschmid.net
***
Outlook 2007 Performance Update: http://pschmid.net/blog/2007/04/13/105
Office 2007 RTM Issues: http://pschmid.net/blog/2006/11/13/80
***
Customize Office 2007: http://pschmid.net/office2007/customize
RibbonCustomizer Add-In: http://pschmid.net/office2007/ribboncustomizer
OneNote 2007: http://pschmid.net/office2007/onenote
***
Subscribe to my Office 2007 blog: http://pschmid.net/blog/feed

Are you running the Outlook Performance Update already?

Patrick Schmid [OneNote MVP]

I have no idea what that is. Was it part of Windows Update? I've had no
problems with Outlook 2007 otherwise... performance-wise anyway-- other
than
this Excel problem.
I'll research this update.

 

[Patrick Schmid [MVP]]

Sorry, it is "outlook /safe"

The update does resolve the problem. Thank you for pointing me to it.

--
-C. Moya
www.cmoya.com

See the link in my signature. It addresses a serious performance issues
with PSTs/OSTs that are 1 GB or bigger, but I would personally recommend
everyone to install it.

Patrick Schmid [OneNote MVP]
--------------
http://pschmid.net
***
Outlook 2007 Performance Update: http://pschmid.net/blog/2007/04/13/105
Office 2007 RTM Issues: http://pschmid.net/blog/2006/11/13/80
***
Customize Office 2007: http://pschmid.net/office2007/customize
RibbonCustomizer Add-In: http://pschmid.net/office2007/ribboncustomizer
OneNote 2007: http://pschmid.net/office2007/onenote
***
Subscribe to my Office 2007 blog: http://pschmid.net/blog/feed

Are you running the Outlook Performance Update already?

Patrick Schmid [OneNote MVP]

I have no idea what that is. Was it part of Windows Update? I've had no
problems with Outlook 2007 otherwise... performance-wise anyway-- other
than
this Excel problem.
I'll research this update.

 

[C. Moya]

I don't have a virus scanner turned on. And testing revealed that the
problem had nothing to do with VPN. Anytime Excel was "blocked" (an empty Do
Loop macro, for instance), Outlook would be blocked as well. (actually it
would block only when you tried to do certain things... like close a new
message window).

The Performance Update solved the problem tho.

--
-C. Moya
www.cmoya.com

Do you have your virus scanner integrated with Outlook or email in
general? If yes, switch that off, as it only costs performance but doesn't
add any protection.
If you disconnect the VPN and then try to repro it, can you still repro
it?
How about if you leave the VPN connected, but open Outlook in safe mode
(start, run, "outlook /a"). Still a repro?
If you open Outlook in safe mode and disable your virus scanner (all of
it, not just the Outlook integration), still a repro?

Patrick Schmid [OneNote MVP]
--------------
http://pschmid.net
***
Outlook 2007 Performance Update: http://pschmid.net/blog/2007/04/13/105
Office 2007 RTM Issues: http://pschmid.net/blog/2006/11/13/80
***
Customize Office 2007: http://pschmid.net/office2007/customize
RibbonCustomizer Add-In: http://pschmid.net/office2007/ribboncustomizer
OneNote 2007: http://pschmid.net/office2007/onenote
***
Subscribe to my Office 2007 blog: http://pschmid.net/blog/feed

The update does resolve the problem. Thank you for pointing me to it.

--
-C. Moya
www.cmoya.com

See the link in my signature. It addresses a serious performance issues
with PSTs/OSTs that are 1 GB or bigger, but I would personally
recommend
everyone to install it.

Patrick Schmid [OneNote MVP]
--------------
http://pschmid.net
***
Outlook 2007 Performance Update: http://pschmid.net/blog/2007/04/13/105
Office 2007 RTM Issues: http://pschmid.net/blog/2006/11/13/80
***
Customize Office 2007: http://pschmid.net/office2007/customize
RibbonCustomizer Add-In: http://pschmid.net/office2007/ribboncustomizer
OneNote 2007: http://pschmid.net/office2007/onenote
***
Subscribe to my Office 2007 blog: http://pschmid.net/blog/feed


Are you running the Outlook Performance Update already?

Patrick Schmid [OneNote MVP]

I have no idea what that is. Was it part of Windows Update? I've had
no
problems with Outlook 2007 otherwise... performance-wise anyway--
other
than
this Excel problem.
I'll research this update.