98.7% 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:
TestimonialsNHS
Information Analyst Meri Petrovska Excel VBA Intro Intermediate This is my 4th course with STL and I am very, very happy with the service that you provide. I will use you again! Thanks! Harcus Sinclair
Paralegal Chidi Onyeche Excel Intermediate It is great. Really useful and well taught. Very impressed. JLL
Retail Liaison Manager Gary Davis Excel Intermediate This was an excellent course - to be honest I was expecting it to be useful but not necessarily enjoyable! However I have never been more excited to go back to the office and start working on my spreadsheets. I've learnt loads of excellent tips (I will save myself hours with the shortcuts alone) and I have no doubt that the quality of my work and the output will improve and be more professional. I was always anxious to start a spreadsheet from scratch and have been amending others work for years - now I know that I can design a workbook or worksheet to do exactly what I want it to do. Max was enthusiastic and personable - he really made everything seem simple and took the fear out of formulas. Will be recommending STL to others - and hopefully I will be back for the advanced course soon! |
PUBLICATION GUIDELINES