98.9% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsPrevious article Next article
Excel articles
Coping With Compatibility In Excel 2007
Fri 21st May 2010
Compatibility mode relates to someone with Office 2003 being able to open an Office 2007 document without it being too garbled or corrupt. Excel needed special consideration, because some features that are extremely useful in 2007 will cause 2003 to display data incorrectly or with bits missing - no good! A good example is that the number of rows possible increased in 2007 - if you send a huge spreadsheet back to someone with 2003, it will just miss off anything over the old total.
There are some elements of Excel 2007 that have to be suppressed or missed out in order for them to work in 2003. If you're frequently sharing your data, it would be a good idea to familiarise yourself with them so that you know what the viewer can or can't see. Imagine sending a report to your boss who is working from home, only to find that they can't view your work because you didn't check it for backwards compatibility. The same goes for if you're trying to read something from a colleague - if you know what features they are trying to share that you can't see, you can advise on how to better distribute worksheets with colleagues and peers.
Most of the alterations are to do with the sheer number of functions 'allowed' in one version to another (with Excel 2007 having more). Compatibility mode will reduce 2007's capacities for columns, rows and function arguments so that 2003 can cope with them. The complexity and size of the functions is also far less in 2003 than it is in 2007, so these will be restricted too. Pivot Tables are another thing that you will have to consider in Compatibility Mode. They are programmed in a new, improved way in Excel 2007 that doesn't always correspond to the way they were constructed by the programme in 2003, so exercise additional caution when manipulating your data in this way.
If you're the lucky Excel 2007 worker having to share your data with a 2003 user, there is a handy tool: the Compatibility Checker. This will look at all your workbooks and spreadsheets, identifying potential problems that your end user might experience with your work. If you're working in Compatibility Mode, this will run in the background (after saving) and alert you to any problems.
Overall, compatibility checking is not only courteous, it's professional. There's nothing more frustrating than not being able to read someone's data because they just presumed you'd have the same software. Now that you have the Compatibility Mode and Checker built into Excel 2007, there's no excuse to send your data anywhere, and to anyone you choose - and that's the beauty of collaborative working when it comes to complicated spreadsheets. Don't let compatibility stand in the way of yours!
Author is a freelance copywriter. For more information on excel training london, please visit https://www.stl-training.co.uk
Original article appears here:
https://www.stl-training.co.uk/article-908-coping-with-compatibility-in-excel-2007.html

London's widest choice in
dates, venues, and prices
Public Schedule:
On-site / Closed company:
TestimonialsPKF Littlejohn
Tax Administrator Coordinator Nicola Sheldrake PowerPoint Intermediate Advanced Really enjoyed the course, when getting stuck time was allowed to be helped Beyond Analysis Ltd
Accounts Assistant Cassandra Bradley Excel Advanced Course was not what I had expected at all in the best possible sense. The Trainer was friendly and made the course material interesting and relevant with great examples of where functions could be applied and held my attention through the entire session. Topics covered were practical and will be extremely useful when applied at work. Thank you STL. Hexcel Composites Ltd
Production Operative Jakub Plesnarowicz Introduction to Management It's all good, trainer Tony B was very thoughtful and understood mamy aspects that normally aren't mentioned by other trainers. |
PUBLICATION GUIDELINES