FAQ
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
