Excel Problem - single worksheet using a load of RAM. - HotUKDeals
We use cookie files to improve site functionality and personalisation. By continuing to use HotUKDeals, you accept our cookie and privacy policy.
Get the HotUKDeals app free at Google Play

Search Error

An error occurred when searching, please try again!

Login / Sign UpSubmit

Excel Problem - single worksheet using a load of RAM.

£0.00 @
Im running an excel spreadsheet with 4 separate work sheets, they all have names and address of clients in and I run a VBA maco to format the name and address correctly before coping them into the lis… Read More
leecher Avatar
7y, 2m agoPosted 7 years, 2 months ago
Im running an excel spreadsheet with 4 separate work sheets, they all have names and address of clients in and I run a VBA maco to format the name and address correctly before coping them into the list.

However one of my worksheets is using a TON of ram everytime I try and work on it for no reason I can see as every worksheet has the same type of data and roughly the same amount.

Im using Excel 2007 and my spreadsheet is Macro enabled the laptop im using has a Core2Duo 2.0 with 3.12GB RAM.

Anyone got any ideas...or can suggest a forum where this question might be more suited?
Tags:
leecher Avatar
7y, 2m agoPosted 7 years, 2 months ago
Options

All Comments

(4) Jump to unreadPost a comment
Comments/page:
1 Like #1
any chance the VB has any looping algorythms? any misscoded parts that are causing it to run for to long...I havent worked with VB for a good few years but just an idea ....maybe the arithmetic being used is hitting a character or you've got a very large answer???
1 Like #2
Save it as excel 97-2003 workbook. :thumbsup:
1 Like #3
Try an open and repair. I've had similar symptoms with a relatively basic spreadsheet that had become slightly corrupted.
1 Like #4
I got it!!!

ODB_69 sent me a PM which said when you copy and paste between sheets it also takes across the formatting so I changed the paste mode to special and just copied across the values only rather than a standard copy and paste.

Thanks very much to everyone who tired to help, maybe Micro$oft should warn the user when this problem is happening.

Thanks ODB_69

Post a Comment

You don't need an account to leave a comment. Just enter your email address. We'll keep it private.

...OR log in with your social account

...OR comment using your social account

Thanks for your comment! Keep it up!
We just need to have a quick look and it will be live soon.
The community is happy to hear your opinion! Keep contributing!