Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel macros run out of memory in Windows Vista
Please help. My new Dell laptop came with Windows Vista. I transferred some
Excel spreadsheets from my Windows XP desktop computer (also a Dell) to my new laptop. Those spreadsheets were created in Windows XP and are the heart of my business. Their macros, though voluminous, ran fast and perfectly in XP. Now, on my laptop, they can't even finish their processing due to running out of memory. My laptop has three gigs of RAM whereas my 5-year-old desktop has only 512k. How can I get my macros to fully run within my laptop? Thank you. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel macros run out of memory in Windows Vista
What version(s) of Excel ? XL2007 is reported to be slower than previous
versions. Hard to say anything else without seeing any code or knowing what the macros are doing... Tim "horsepro001" wrote in message ... Please help. My new Dell laptop came with Windows Vista. I transferred some Excel spreadsheets from my Windows XP desktop computer (also a Dell) to my new laptop. Those spreadsheets were created in Windows XP and are the heart of my business. Their macros, though voluminous, ran fast and perfectly in XP. Now, on my laptop, they can't even finish their processing due to running out of memory. My laptop has three gigs of RAM whereas my 5-year-old desktop has only 512k. How can I get my macros to fully run within my laptop? Thank you. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel macros run out of memory in Windows Vista
As Tim says, it's hard to know what the problem is without knowing more about
what the code does, but one possibility is that if, for instance, the macros performed some kind of loop over the entire sheet/workbook, they may be doing a lot more work in XL2007 than in XL2003 (assuming these are the Excel versions you are going to and from). That is just a guess though... -- There are 10 types of people in the world - those who understand binary and those who don't. "horsepro001" wrote: Please help. My new Dell laptop came with Windows Vista. I transferred some Excel spreadsheets from my Windows XP desktop computer (also a Dell) to my new laptop. Those spreadsheets were created in Windows XP and are the heart of my business. Their macros, though voluminous, ran fast and perfectly in XP. Now, on my laptop, they can't even finish their processing due to running out of memory. My laptop has three gigs of RAM whereas my 5-year-old desktop has only 512k. How can I get my macros to fully run within my laptop? Thank you. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
cannot open exel from windows xp in windows vista and visa versa | New Users to Excel | |||
Windows Vista and Excel 2000 -- incompatibility? | Excel Discussion (Misc queries) | |||
can windows vista edit shared document from windows xp | Excel Worksheet Functions | |||
Excel 2003 on Windows Vista | Excel Discussion (Misc queries) | |||
How to transfer Vista Excel file to Windows XP? | Excel Discussion (Misc queries) |