Rental Workbook on a Tablet PC or iPad, or in Office 365?
we have had many queries as to whether the Rental Workbook would work on a Tablet or iPad hand-held computer.
As the Rental Workbook is highly programmed in VBA (Visual Basic for Applications) for Excel, it requires a full install of Microsoft Excel, with Macros Enabled to run. Most Tablet PC’s or ‘Pad’ computers do not have this capability.
Similarly, the new Cloud version of Office (Office 365) has the same disadvantage, for the same reasons.
This post online gives an example of a similar problem experienced by a Word user:
http://www.androidtablets.net/forum/android-tablet-apps/12532-ms-office-vba-development-tablet.html
New Tax Year
Each tax year brings a fresh update to the Rental Workbook. One of our Frequently asked questions is “I can’t see the new tax year – how can I get it there?”.
Every July, we obtain the new Tax Table information from the ATO, add the details to the RW and begin work on testing. Near the end of July, we issue all existing users with instructions on how to upgrade their files. If you are an existing subscriber, make sure we have your up to date email contact information so that you receive this vital update.
Investors Club Members Discount
Are you an Investors Club member? Ask your Support Member for your discount code, and get $25.00 off the RRP!
Problem after upgrade or renewal
After running an upgrade or renewal, the licence key should be confirmed.
How to do this:
Excel 2007 or 2010
Go Add-ins > Rental Workbook > Utilities > Enter Software Licence
Excel 2003 or older
Rental Workbook > Utilities > Enter Software Licence
Line of Credit Extra lines
For all those people who want to record every transaction on their Line of Credit, we’ve created a free Line of Credit Calculator.
This allows input of up to 1,000 transactions per property per year and generates monthly totals that can then be input into the Rental Workbook, or simply provided to your accountant.
It’s particularly useful if you use your LOC for both personal and investment purposes as it automatically splits transactions into each type and tracks the balances.
Free download from our downloads page at http://www.excelaustralia.com.au/downloads/
Lost Data after Upgrade or Renew
Normally, when data is lost or missing, it is because properties were not saved before the upgrade. This is an important step and is not the same as saving the file.
Please check that you have followed the upgrade or renew steps fully and correctly.
If you have followed all steps and you are still losing data on the upgrade or renewal then send us your old Rental Workbook with an email explaining what you have tried to:
support@excelaustralia.com.au
Upgrade or Renewal – Detailed instructions
Important – Please read before upgrading
Before you upgrade, you should properly prepare your existing Rental Workbook.
Renewal problems
Our renewal process is always set to run on the most up to date version of the Rental Workbook. – We issue a new version every July to include all of the new Financial Year updates.
Upgrade or Renewal problems – Excel 2007 user
If you are using Excel 2007, you may have saved your original Rental Workbook as an Excel 2007 file type (e.g. WorkbookName.xlsx)
In order that the Rental Workbook is compatible with most versions of Excel, we use the Excel 97-2003 file type (e.g. WorkbookName.xls) › Continue reading
Excel 2007 or 2010- Setting up Excel for the Rental Workbook
If you’re using Excel 2007 or 2010, you may not have all of the Rental Workbook program working due to the macros not being ‘enabled’.
With these versions of Excel, there are a few extra steps needed to make sure all the macros are accepted – Microsoft have made lots of security enhancements which means that programs that use the security sections (like us) have to work a little harder!
CAUTION: In Excel 2010; If you do not enable Macros when you first open the RW, and have then saved as an Excel Workbook, you may have removed all the programming code! Excel 2010 has a built-in feature that keeps your settings for a particular file. With normal use, this means you won’t have to keep ‘Enabling Macros’ every time you pen the Rental Workbook.
