My data worksheet is only 1,404 rows and 13 columns (not all data being used)
- but every time I try and add a formula I get an message: "There are too
many records to complete the operation".

I also have an issue when I go to move from items between the columns and
rows - it takes over 15 minutes to refresh.