Whats wrong with Excel 2007 on Vista?

Posted: 02-15-2007, 02:44 PM
I have a test rig with Office 2007 standard and Vista Enterprise:
I have another test rig but with Windows 2003 SP1 and Office 2003 Pro:
Both installations are vanilla and are on a brand new Vista accredited Dell
machine.

I wrote an Excel spreadsheet that includes a common VBA module which only
iterates through ranges of cells changing the values as it goes.

On the Win2003/Office2003 rig the VBA task completes in 5 secoonds.
On the Vista/Office2007 rig it takes 118 seconds (whether in compatibility
mode or after being saved as a macro enabled worksheet)

I have even rewritten the spreadsheet from scratch on the Vista/2007 rig as
a macro enabled workbook and that takes only 18 seconds to complete its
execution.

I'm quite worried that we may have to redevelop a significant number of
spreadsheets to accomodate this problem and that even then the result will be
that we will be working much slower with a new desktop than we were with our
old one.

These tests are being done because we need to know if our intention to
deploy Vista/Office2007 would be a mistake.... Currenetly I suspect the it
may indead be a major mistake to deploy the Vista/Office2007 combination.

If anyone has any constructive ideas that may help me with this problem then
please please speak up.
Reply With Quote

Responses to "Whats wrong with Excel 2007 on Vista?"

AJR
Guest
Posts: n/a
 
Re: Whats wrong with Excel 2007 on Vista?
Posted: 02-15-2007, 06:26 PM
"Windows 2003 SP1" ?

@i

"NickLeeds" <NickLeeds@discussions.microsoft.com> wrote in message
news:3AD5B0DA-646F-4709-BF10-3024156C67A3@microsoft.com...
>I have a test rig with Office 2007 standard and Vista Enterprise:
> I have another test rig but with Windows 2003 SP1 and Office 2003 Pro:
> Both installations are vanilla and are on a brand new Vista accredited
> Dell
> machine.
>
> I wrote an Excel spreadsheet that includes a common VBA module which only
> iterates through ranges of cells changing the values as it goes.
>
> On the Win2003/Office2003 rig the VBA task completes in 5 secoonds.
> On the Vista/Office2007 rig it takes 118 seconds (whether in compatibility
> mode or after being saved as a macro enabled worksheet)
>
> I have even rewritten the spreadsheet from scratch on the Vista/2007 rig
> as
> a macro enabled workbook and that takes only 18 seconds to complete its
> execution.
>
> I'm quite worried that we may have to redevelop a significant number of
> spreadsheets to accomodate this problem and that even then the result will
> be
> that we will be working much slower with a new desktop than we were with
> our
> old one.
>
> These tests are being done because we need to know if our intention to
> deploy Vista/Office2007 would be a mistake.... Currenetly I suspect the it
> may indead be a major mistake to deploy the Vista/Office2007 combination.
>
> If anyone has any constructive ideas that may help me with this problem
> then
> please please speak up.

Reply With Quote
Pavel
Guest
Posts: n/a
 
Re: Whats wrong with Excel 2007 on Vista?
Posted: 02-15-2007, 08:53 PM
Same problem with Access 2007 under WindowsXP or Vista.

Pavel

"NickLeeds" <NickLeeds@discussions.microsoft.com> wrote in message
news:3AD5B0DA-646F-4709-BF10-3024156C67A3@microsoft.com...
>I have a test rig with Office 2007 standard and Vista Enterprise:
> I have another test rig but with Windows 2003 SP1 and Office 2003 Pro:
> Both installations are vanilla and are on a brand new Vista accredited
> Dell
> machine.
>
> I wrote an Excel spreadsheet that includes a common VBA module which only
> iterates through ranges of cells changing the values as it goes.
>
> On the Win2003/Office2003 rig the VBA task completes in 5 secoonds.
> On the Vista/Office2007 rig it takes 118 seconds (whether in compatibility
> mode or after being saved as a macro enabled worksheet)
>
> I have even rewritten the spreadsheet from scratch on the Vista/2007 rig
> as
> a macro enabled workbook and that takes only 18 seconds to complete its
> execution.
>
> I'm quite worried that we may have to redevelop a significant number of
> spreadsheets to accomodate this problem and that even then the result will
> be
> that we will be working much slower with a new desktop than we were with
> our
> old one.
>
> These tests are being done because we need to know if our intention to
> deploy Vista/Office2007 would be a mistake.... Currenetly I suspect the it
> may indead be a major mistake to deploy the Vista/Office2007 combination.
>
> If anyone has any constructive ideas that may help me with this problem
> then
> please please speak up.
Reply With Quote
Chad Harris
Guest
Posts: n/a
 
Re: Whats wrong with Excel/Not setup question. Post in Genral or excel.
Posted: 02-16-2007, 04:16 PM
I'd take this to one of the Excel groups. I don't mind answering Office
question on the Vista general group. I fail to see this as a setup
question. You posted it on a Vista setup group.

CH


"NickLeeds" <NickLeeds@discussions.microsoft.com> wrote in message
news:3AD5B0DA-646F-4709-BF10-3024156C67A3@microsoft.com...
>I have a test rig with Office 2007 standard and Vista Enterprise:
> I have another test rig but with Windows 2003 SP1 and Office 2003 Pro:
> Both installations are vanilla and are on a brand new Vista accredited
> Dell
> machine.
>
> I wrote an Excel spreadsheet that includes a common VBA module which only
> iterates through ranges of cells changing the values as it goes.
>
> On the Win2003/Office2003 rig the VBA task completes in 5 secoonds.
> On the Vista/Office2007 rig it takes 118 seconds (whether in compatibility
> mode or after being saved as a macro enabled worksheet)
>
> I have even rewritten the spreadsheet from scratch on the Vista/2007 rig
> as
> a macro enabled workbook and that takes only 18 seconds to complete its
> execution.
>
> I'm quite worried that we may have to redevelop a significant number of
> spreadsheets to accomodate this problem and that even then the result will
> be
> that we will be working much slower with a new desktop than we were with
> our
> old one.
>
> These tests are being done because we need to know if our intention to
> deploy Vista/Office2007 would be a mistake.... Currenetly I suspect the it
> may indead be a major mistake to deploy the Vista/Office2007 combination.
>
> If anyone has any constructive ideas that may help me with this problem
> then
> please please speak up.
Reply With Quote
 
LinkBack Thread Tools Display Modes
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may 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 On
Forum Jump


Similar Threads
Thread Thread Starter Forum Replies Last Post
Printing an excel 2007 sheet landscape style on windows vista brenda oblitas Windows Vista Printers & Scanners 3 05-18-2007 11:48 PM
whats wrong with my Vista DVD ??? Xibit Windows Vista Install & Setup 15 10-01-2006 12:38 AM
FPS Really LOW - Whats Wrong? John W. Windows XP Video 1 01-19-2004 11:33 PM
FPS Really LOW - Whats Wrong? John W. Windows XP Games 2 01-19-2004 04:37 PM
Whats wrong here Karl McCoy Windows XP Basics 0 09-03-2003 08:02 PM