problem saving xlsx file

[mohavv]

Hi,

Have one big file with data (310,000 rows) size is approx. 28MB.
I named several colums

In a separate file (.xlsx) I entered a SUMIFS formula using the range
names.

When I try to save the new file, Excel (2007) hangs every time.

Does this look familiar to someone, is there a solution?

Cheers,

Harold

 

[Paul]

Harold,

If I understand you correctly, you have named ranges which cover ENTIRE
columns
The SUMIF fomulas are also testing 690, 000+ blank rows. That's a lot of
work.
Restrict the name ranges to just the data rows.

That should improve matters.

Regards

Paul