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


"mohavv" wrote in message
...
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