Monthly Archives: November 2010

Line of Credit Extra lines

Posted on by
Reply

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

Posted on by
Reply

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

Setting up Excel for the Rental Workbook

Posted on by
Reply

If you’re using Excel, you may not have all of the Rental Workbook program working due to the macros – the programming part of the Rental Workbook – not being ‘enabled’.

With these newer versions of Excel, there are a few 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.

Continue reading →

Renew, Rollover and Upgrade – What’s the difference?

Posted on by
6

There are three separate processes to explain

1) Renewal – This is your annual subscription. Once payment has been processed, we send you a renewal document that runs through a process that gives you another 12 months usage of the Rental Workbook. Always save each of your properties (Rental Workbook > Property > Save) before running a renewal; and then save a backup copy of your Rental Workbook. If you need to renew your Rental Workbook, visit our website and purchase your downloadable renewal at http://www.excelaustralia.com.au/purchase/

Continue reading →

Is it possible to enter past data for properties?

Posted on by
Reply
Is it possible to enter data for properties which have been owned a number of years? Does this mean old data has to be individually entered for each year in retrospect until the first year of ownership. Is it suffice to enter the purchase price and the year purchased and then enter the current year’s income and expenditure?Answer: Continue reading →

Rental Workbook on a Mac?

Posted on by
5

We have had a number of inquiries about Excel, the Rental Workbook, and whether it will work with  Macs.

We recently discovered that the VBA functionality has been included in Excel for Mac 2011.  This is an important feature as it supports all of the Excel application objects and methods of Excel 2010 for Windows.  This makes this version for Mac a more viable option and we are investigating the Rental Workbook to see how it works with the Mac.  This is very good news, as previous Office for Mac versions have not been able to run the Rental Workbook.

We did discover though, that external objects referenced within VBA projects are limited within Excel for Mac 2011 in cases where the Windows based objects are not available on Mac OS X.  This means that when Upgrading or Renewing, Mac users will need to refer to us for processing because the Renewal and Upgrade files are referencing  the ‘External Object’ which is the users own Rental Workbook file. We can run this process for users manually, returning the Renewed or Upgraded file back to the client without a problem (on recent tests at least).

Continue reading →

I seem to have an EFW file?

Posted on by
Reply

The file we send through is a normal ,ZIP file containing an Excel document, so not a .EXE.

An EFW extension is a Compressed .ZIP or executable .EXE file renamed by CA Security Centre to have a “.efw” extension; typically applies to e-mail attachments scanned by Computer Associates (CA) antivirus software. (In our case it would have been a .ZIP file). See this post at Filext for more information: http://filext.com/file-extension/EFW Continue reading →