Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming
external usenet poster
 
Posts: 4
Default Excel 2000 macro for page format slow

HI all -

I have a laptop with Windows XP professional and Office 2000. At other
times I had Office XP and Office 2003 installed but have removed those
via Add/Remove programs and also gone to the file system as well as the
registry to remove traces of Office XP/Office 2003. I have also
removed and re-installed Office 2000 as well as the SP-3.

Anyway, I have a macro I had created and saved as an add-in to do
several Page Setup actions. This macro ran in about 20 seconds before
all of my upgrades/changes. Now it takes about 2-3 minutes. My other
machine (PC) has Windows XP Professional and Office 2000 (SP-3) and the
macro still takes 20 seconds as expected after the SP-3 update.

I even upgraded the laptop from 256MB to 512MB memory to match the PC
but the laptop is still slow with the macro. I notice that when I look
at task manager while running the macro on the laptop, in the programs
tab it shows 2 instances of my excel file (but only one EXCEL.EXE
process). But the two instances only come up when I run the macro on
the laptop and not on the PC. (And if I just open the file on the
laptop without running the macro it just has one instance of the file.)

Does anyone have any suggestions on how to proceed? I had seen and
tried several remedies for slow Excel 2000 after SP-3 update. I
suspect that something about the Office 2003 and Office XP is still
hanging around and causing probs. I have also gone to the macro and
re-saved and deployed the add-in but still no luck.

Or is there a better way other than the macro/add-in approach to format
an Excel spreadsheet?

Thanks!
S

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
My Excel 2000 changes the format of my numbers, how do I correct? Dell Excel Discussion (Misc queries) 3 February 13th 07 11:16 PM
error when running cut & paste macro Otto Moehrbach Excel Worksheet Functions 4 August 9th 06 01:49 PM
Running Excel 2000 VBA Application on Excel 2003 Excel Worksheet Functions 0 August 8th 06 06:04 PM
Macro help: File path in Excel 2000 macronewfie Excel Discussion (Misc queries) 2 May 26th 06 02:21 PM
Excel 2000 using Web Query is slow on Excel 97 [email protected] Excel Discussion (Misc queries) 0 April 10th 06 06:10 PM


All times are GMT +1. The time now is 07:24 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"