When I try and save my record book I get the following warning in Excel 2007/2010.

DON'T DO IT!   This will remove the macros (functions that display menus, link record books etc.).  See below.   Save your record book in Excel 2003 format (.XLS).

I'm using Excel 2007 or 2010 and there is no Add-in menu. 

Check the file extension of your record book file.  If it is .XLXS then you have saved the record book in the new format which does not allow macros.  You will need to recover an old backup of the file in the Excel 2003 format (.XLS).  If you don't have a backup you will need to re-enter your data in a new record book to have the macros function again.  A workaround can be used to recover your data:

1.     Download a new record book for CalAgEd

2.   Open the blank record book and just minimize it.

3.   Open your record book and the menus should be available (as long as the blank book is open).

Will the e record book work with Windows Vista or Windows 7?

Yes. 

I have Excel 2007; will the e record book work with this version?

Yes.   Menus will be found under Add-Ins (in the "ribbon").  The macro security is different from Excel 2003. See: Enable Macros Excel 2007  Note:  Another method of addressing macro security is to set the trust settings to a specific drive or directory where the erecordbook is located. 

I get a message about Macro Security

The Excel record book uses macros and Excel's default behavior (high security) is to not allow macros to be run.  You will need to reset your security level to properly use the record book.  Please see the Acrobat document Excel Macro Security.pdf for details on how to change your security level.  NOTE: Excel security can be accessed from the Tools | Options menu or the Tools | Macro menu.  For Excel 2007 see above.

When I drag (move) or cut and paste the contents of a cell, the lines around the cell disappear.

This the default behavior of Excel.  Use copy and paste then delete the contents of the original cell.

Formula is not working in Current Operating Inventory and Non-Current/Non-Depreciable Inventory pages on lines 4-6. 

Workaround this problem by skipping the effected lines (only in the first three enterprises).  An updated file is now available (version 1.01) that fixes this problem.

The Financial Statement, under personal assets, line d, it has the following statement: " Value of Non-Current/Capital Non-Depreciable Inventory".

The description should not be there.  The cell is unprotected, simply delete the description.

When I open the Excel file from the CD I can't save the data. 

The CD is a read only copy of the record book.  You must copy the file to your hard disk before actually using the record book.

The third Ownership agreement does not automatically add in the name.

No workaround exists at this time.  Print the agreement and hand write the student's name. 

Why are my placement and ownership project hours not showing on the Income Statement?

The project type is not selected on the the Introduction Page.

Why are some of the pages missing from the Record Book Menu?

Windows automatically hides seldom used menu items. Click on the bottom of the menu to reveal all the items. See the Tools | Customize dialog box to make full menus always display (Options tab).

A page (other than the journal) prints on more than one page.

If a page is printing to more than one sheet of a paper, go to "File", "Page Setup", select the tab "Page" and select "Fit to: '1' page(s) wide by '1' page(s) tall.  This behavior may vary by type of printer since different models of printers produce slightly different size fonts.

In Depreciable Property Inventory the Cost Basis Total is incorrect (also causes Capital Assets Purchased line to be understated on the income statement).

There are several reasons this may occur: a) Total should be for only those assets that were purchased in the current year.  b) A formula error is causing rows 13-16, 31-34, 52-59. and 69-76 to not be considered for the total.  Workaround by not entering assets purchased in the current year in these rows.

One or more formulas is showing as "# Ref".

One or more of the formulas in the spreadsheet references an unprotected cell that you have moved (or cut).  If you can, use undo to go back to a point before the cell was moved.  Go back to an earlier version of the spreadsheet (good reason to keep backup copies).  There does not appear to be a way to prevent this from happening, but we are looking into it.

If you are unable to download the record book file to your desktop (or other folder).

Please try the following steps.

1. Click on the My Computer, or My Documents to open an Explorer Window.
2. From the menu choose Tools | Folder Options
3. Choose the File Types tab, find and select the file type "XLS Microsoft Excel Worksheet"
4. Go to "Advanced Settings"
5. Click on "Confirm after download"
6. Click on OK.  Then Click on Close.

I get an error about Range _Global Failed when trying to to a prior record book.

Check the Excel file name(s) for single quotes (ex.  Bill's Record Book).  Remove and try again.

Journal does not match Income Summary

Change months on the cover page to 18 and check for hidden months on the Journal.  While reducing the number of months hides unused pages, entries are not deleted.

Depreciation is only 1/2 year even though this is not the first year. 

Check to see that the asset does not have a Sold Amount.