Not enough memory- fixed (well kind of)

AmberJo · May 8th, 2002, 06:20 PM

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

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 ]

James · May 8th, 2002, 06:27 PM

Wait a minute, you said 13,000 columns? Are you sure about that?

James

Chris Davison · May 10th, 2002, 12:34 PM

so you have a summary sheet that has lots of SUMIFs on it, relating to a 13,000 row sheet somewhere else ?

Nimrod · May 10th, 2002, 12:39 PM

Could a Pivot Table instead of SumIf's be a solution ?
What type of database are you using for the source ?

Q · May 10th, 2002, 12:52 PM

Buy more RAM.

Jack in the UK · May 10th, 2002, 01:01 PM

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?

Nimrod · May 10th, 2002, 01:06 PM

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 ]

May 10th, 2002, 01:01 PM	#6
Jack in the UK Board Regular Join Date: Feb 2002 Posts: 3,064	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? __________________ Free Excel based Web Toolbar available here. Jack in the UK J & R Excel Solutions "making Excel work for you"

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 8th, 2002, 06:20 PM	#1
AmberJo New Member Join Date: Apr 2002 Location: Uni Credit Union Posts: 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 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 ]

May 8th, 2002, 06:27 PM	#2
James Board Regular Join Date: Feb 2002 Location: Huntington Beach, CA USA Posts: 327	Wait a minute, you said 13,000 columns? Are you sure about that? James

May 10th, 2002, 12:34 PM	#3
Chris Davison MrExcel MVP Join Date: Feb 2002 Location: Millbank, London, UK Posts: 1,790	so you have a summary sheet that has lots of SUMIFs on it, relating to a 13,000 row sheet somewhere else ?

May 10th, 2002, 12:39 PM	#4
Nimrod MrExcel MVP Join Date: Apr 2002 Location: Vancouver BC , Canada Posts: 6,259	Could a Pivot Table instead of SumIf's be a solution ? What type of database are you using for the source ?

May 10th, 2002, 12:52 PM	#5
Q Board Regular Join Date: Apr 2002 Location: 20 Minutes outside Manhattan Posts: 64	Buy more RAM.

May 10th, 2002, 01:06 PM	#7
Nimrod MrExcel MVP Join Date: Apr 2002 Location: Vancouver BC , Canada Posts: 6,259	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 ]