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