Renew, Rollover and Upgrade – What’s the difference?
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/
How do I enter expenses that cover more than one property?
You can either apportion these between each property, or enter each property’s share of the total on its expense sheet; alternatively, you can simply choose one property as your “default” property and put the whole expense into that property’s sheet. › Continue reading
Is it possible to enter past data for properties?
Answer: › Continue reading
Rental Workbook on a Mac?
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).
More than one tenant per property
This is a common question: I have more than one tenant in a property – what do I do to record their rents and see if each individual is in arrears / ahead in their payments? › Continue reading
I seem to have an EFW file?
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
This workbook has lost its VBA project
An error that has appeared for one or two of our clients who also use Excel 2007 has been to see an error message titled: “This workbook has lost its VBA project….” › Continue reading
Rental Workbook on Open Office?
We have had a number of inquiries about Excel, the Rental Workbook, and different spreadsheet programs such as OpenOffice.
OpenOffice from OpenOffice.org does not come with VBA support, which means it will not run any coding or macros created in Excel. According to web research, you may be able to try a complete build of version 2.4, though we cannot offer support for non-Microsoft issues. › Continue reading
File Error: Data may have been lost
We’ve had reports from a number of customers regarding the issue you reported where they were using a combination of Excel 2000 and Internet Explorer (“IE”) 7 or 8. (Not so much recently, as a lot of people have since upgraded to version 2007).
Update: This error now appears with some installs of Office 2003. for reference, please read this Microsoft update article. If you have Service Pack 2 installed (SP2), you may be able to download a hot-fix at this Microsoft update page, which also explains how to download SP2 if you don’t yet have it. Please note, once Microsoft issue their next update for Office 2010, Office 2003 will no longer be supported so the following paragraphs will also apply. › Continue reading
New Services
Hello again,
In keeping with my enthusiasm for Excel, I’m going to be putting tips into this blog. With this in mind, I am also highlighting our training services.
Based in South East Queensland, we can offer a range of Microsoft Training as very reasonable rates. We come to your offices, so we don’t have the overheads of room hire, so you are only paying for our trainer to come to you.
Before the training, we discuss suitable topics to cover for your firm, and produce PDF help cards for you to keep at your offices. See our Training page for more information, or contact us using the link alongside this post.
First in a series of Excel tips, is to introduce Paste Special.
Paste Special is a very useful command that can be used for a wide range of copying and pasting techniques. It is designed to make sure that you never need to enter information or create formats more than once. All you do is let Paste Special know which aspect of the cell(s) you want.
It can be used to copy a single element such as comments, column widths, formats or validation without copying the remaining cell values. The value of copying formats only is that you can ensure that formatting remains consistent throughout your workbook.
As long as the cell remains in copy mode (with the flashing ‘ants’ around the selection), it is possible to copy different elements, one at a time. For example, first paste the column widths and then without pressing ESC, paste the cell formatting.
1. Select the cell (or range of cells) that you want to copy.
2. Then copy.
Copy cell(s)
3. Go to the location where you wish the properties to be copied.
4. Choose the drop-down from the Paste tool (or Right-click and select Paste Special).
Look at the options for paste special – you can choose to paste only the column widths, or even just the cell values, meaning that the formulas from the cell stay where they are, and only the numbers go to your new location.
Have fun learning how to use Paste Special, and watch for our next post 
Steps to paste the options
