Not enough memory- fixed (well kind of)

AmberJo

New Member
Joined
Apr 15, 2002
Messages
17
For the problem below I cheated completely and simply did a 'paste value' to create a new spreadsheet to refer to, making my 13000 row spreadsheet much less complex. My summary worksheet now refers to this less complex worksheet and it all seems to work nicely (touch wood).

There's probably a better, more technical way of getting this done- but hey, it works :wink:


I've got a wonderful spreadsheet with lots of sumif functions that link to another spreadsheet... but I don't have enough memory to update outside links (apparently).

HELP

Basically I have a 13000 rows (need more coffee) spreadsheet with all our member details on it that I need to link to in order to nicely summarise the material.

Any ideas greatly appreciated.
This message was edited by AmberJo on 2002-05-08 17:36
This message was edited by AmberJo on 2002-05-08 21:21
This message was edited by AmberJo on 2002-05-12 17:57
 

Excel Facts

Links? Where??
If Excel says you have links but you can't find them, go to Formulas, Name Manager. Look for old links to dead workbooks & delete.
Could a Pivot Table instead of SumIf's be a solution ?
What type of database are you using for the source ?
 
Upvote 0
Hi

AmberJo RAM or correctly memory does not always solve issues but can help..

what spec PC just chip and memory. can i ask about windows and excel version?
 
Upvote 0
I had the same problem on my PC that has 512 memory. I had a huge number of formulas pointing all over the place to sum data from a large data-structure. These problems were elimated when I went to using Pivot Tables. If your data source is mdb or excel based this setup can be fairly straight forward. Other data sources are a bit more complicated as you need to set up a OBDC drivers .. permissions etc.
What is your data source ?

_________________
NOTE: Testing performed on Win2K utilizing Office 2000. Solutions may need tweaking for other versions.
This message was edited by Nimrod on 2002-05-10 12:07
This message was edited by Nimrod on 2002-05-10 12:09
 
Upvote 0

Forum statistics

Threads
1,213,494
Messages
6,113,972
Members
448,537
Latest member
Et_Cetera

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top