When I use a name reference to use in lookup functions, the subtotal in the
data sheet is working very slowly.
eg:Sheet: sales-sheet, defined name: sales
Sheet : MonthSummary (this sheet has a vlookup function using defined name
"sales")
now if I do a subtotal function to get the month totals in sales-sheet this
works very slowly.
Can anyone help?