This solution works best when resource intensive formulas are required when compiling data, but are not needed once table of data is fully assembled. I use this for audits between two systems - first I pull all data from both systems into one table using vlookups, then I store the formulas above and work with the static data table I've created.
1)insert a row above or below table headers (if you insert below header, hide the entire row so it doesn't get sorted in with your data)
2)copy any formulas in the table into the newly inserted row above (i.e. formula in column F would be copied into F1)
3)Once all formulas are stored in the row you inserted, select all of your data and then copy/pastespecial(values)
Your entire table is now static data, and making simple changes in the workbook won't cause the entire bulk of your data to recalculate.
Keep Up with TechRepublic