Do not mix numbers with formulas

In Excel, it is better to separate numbers and formulas into different cells. For example, if you wish to multiple by a row of numbers by a certain rate, it is better to create one row of numbers and another row for the rate. Then add in a 3rd row to multiple the first 2 rows together. In this way, you can always see your numbers and rate you entered and you can also change the rates easily. Do not try to save rows by putting the number and rate into one cell or row.

Excel 2003 vs 2007 file format

I had extracted data for a client from their Great Plains financial system quite a few years back and the report was saved in the older excel format that uses the. .xls extension. The file size was 300 MB because I used Macro/VBA to pull more than 3million rows from the system. Recently, my client called me to upgrade the report. I save the file in the newer .xlsm format. I know the file size is likely to drop with the new format but was surprised to see that it dropped from 300MB to almost 30MB. That's a 90% savings in space. Well done, Microsoft for developing the new format.