Filesize too big. How to fix?

[geolefty]

I am not sure if Excel as run out of ability or just the way I have it set up. Or maybe I ran out of ability.

On one sheet I have rows of about 1500 products (50 companies x 30 products) with about 10 columns worth of specs (size, weight, etc.).

On another sheet I have a list of those same products but with shipments from about 10 countries. Resulting in a sheet with about 15,000 rows of data.

I want to use the data I gather from each country but connect it to the specs for each of the products. All products will still have the same specs no matter what the country.


For example,
On the product page I have the "A-1" product with all of its specs.

On the country page I have shipments data for the "A-1" from
Japan, A-1, 53 units
US, A-1, 21 units
India, A-1, 99 units
China, A-1, 33 units
etc.

Now in order to connect the countries with the product (and specs) I was using a lookup formula but it seems to take forever to recalc and do things on the sheet. And it seems very redundant.

I shrunk the file a little by concatenating the specs on the product sheet and performing the lookup on the country sheet only once. Then I used the text functions to split it apart again.

Do I need a database?

Any thoughts or ideas would be greatly appreciated.

thanks in advance.
g

 

[tactps]

It sounds like a lot of data! Unless you can work out how to remove some columns, or replace formulas with values, your sheet is going to grumble when it recalcs.

If you have specific formulas that are inefficient, post them.