ExcelGeek's Freedom Account Spreadsheet

ExcelGeek's Freedom Account Spreadsheet: FAQs


Download the Help Notes and Overview

If you'd like to see the pdf files of the Freedom Account spreadsheet's Help Notes and Overview, they're right here:

[Return to Top]


Does it work with OpenOffice?

No. OpenOffice does not have the ability to execute VBA (Visual Basic) or macros, which the Freedom Account Spreadsheet requires. Because of this, the FA spreadsheet requires Excel 2003 or later.

[Return to Top]


Does it work with Google Docs?

No, for the same reasons as above. The Freedom Account spreadsheet requires VBA code to execute. Google Docs are bare-bones spreadsheets, and do not support VBA code.

[Return to Top]


Does it work on Macs?

Yes, as long as you have Excel 2004 for Mac (or earlier), or Excel 2001 for Mac. Beginning with Version 5, the Freedom Account spreadsheet is fully compatible with Mac OS X and Excel 2004, as well as Excel 2011.

Please note, however, that the Freedom Account spreadsheet will not run in Numbers, nor will it run on Macs with Excel 2008.

[Return to Top]


Does it work on Macs with Excel 2008?

Unfortunately, no. Excel 2008 for Mac does not run VBA code, which the Freedom Account requires. The FA spreadsheet will run only on Macs with Excel 2004 or earlier, or Excel 2011.

[Return to Top]


How do I get the macros to run?

You can find step-by-step instructions on my Excel macros page.

[Return to Top]


Can I get the password to unprotect the spreadsheet?

Unfortunately, no. The spreadsheet contains VBA code and macros and is pretty complex. User customizations would run a high risk of disabling the worksheet altogether. If you have a question or comment about the spreadsheet, however, feel free to contact ExcelGeek via email.

[Return to Top]


Should I start a new spreadsheet each year?

It's a pretty good idea, actually. Here's how to do it:

  1. If your current FA spreadsheet isn't already named by year, you should do this; i.e., use a file name such as FA-2016.xls.
  2. Create a new workbook: Perform a "Save As" and rename the new file with the new year; i.e., FA-2017.xls.
  3. In your new FA-2017 workbook, click the Reset button. Select the "Start New Year" option. This will keep all your categories and budget amounts the same; your 2016 FA transaction details will be deleted; and your end-of-year 2016 balances will be saved as your opening balances for the new year (2017).

[Return to Top]

RSS FeedWant to know when I add to and update my spreadsheets? Subscribe to IYM's feed!

Add to My Yahoo!