A Windows Vista forum. Vista Banter

Welcome to Vista Banter.

You are currently viewing our boards as a guest which gives you limited access to view most discussions, articles and access our other FREE features. By joining our free community you will have access to ask questions and reply to others posts, upload your own photos and access many other special features. Registration is fast, simple and absolutely free so please, join our community today!

If you have any problems with the registration process or your account login, please contact contact support.

Go Back   Home » Vista Banter forum » Microsoft Windows Vista » Installation and Setup of Vista
Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

Installation and Setup of Vista Installation problems and questions using Windows Vista. (microsoft.public.windows.vista.installation_setup)

Whats wrong with Excel 2007 on Vista?



 
 
LinkBack Thread Tools Display Modes
  #1 (permalink)  
Old February 15th 07, 02:44 PM posted to microsoft.public.windows.vista.installation_setup
NickLeeds
external usenet poster
 
Posts: 1
Default Whats wrong with Excel 2007 on Vista?

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.
  #2 (permalink)  
Old February 15th 07, 06:26 PM posted to microsoft.public.windows.vista.installation_setup
AJR
external usenet poster
 
Posts: 1,033
Default Whats wrong with Excel 2007 on Vista?

"Windows 2003 SP1" ?

@i

"NickLeeds" wrote in message
...
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.



  #3 (permalink)  
Old February 15th 07, 08:53 PM posted to microsoft.public.windows.vista.installation_setup
Pavel
external usenet poster
 
Posts: 12
Default Whats wrong with Excel 2007 on Vista?

Same problem with Access 2007 under WindowsXP or Vista.

Pavel

"NickLeeds" wrote in message
...
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.


  #4 (permalink)  
Old February 16th 07, 04:16 PM posted to microsoft.public.windows.vista.installation_setup
Chad Harris
external usenet poster
 
Posts: 3,247
Default Whats wrong with Excel/Not setup question. Post in Genral or excel.

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" wrote in message
...
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.


 




Thread Tools
Display Modes

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

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



All times are GMT. The time now is 08:57 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.Search Engine Optimization by vBSEO 3.0.0 RC6
Copyright ©2004-2024 Vista Banter.
The comments are property of their posters.