Friday, March 23, 2007
Clear Excess Formatting in Excel Files
Microsoft have a very interesting tool on their website.
The Excel Excess Formatting Cleaner Add-in program removes all formatting that has been applied beyond the cell range that contains data, or beyond the cell range that is covered by shapes, in each worksheet in the workbook. This reduces the file size of a converted Lotus 1-2-3 file or of a file that has formatting applied beyond the data range.Once installed you can find the application in the File Menu under Close.
You can also use this add-in program to resolve various printing and viewing problems that are caused by extra formatting that is applied outside the last cell (as defined by the UsedRange property to determine which cells in the worksheet contain data).
This worked brilliantly for the files I tried it on with significant file size decrements of 25%-60%.
As far as I can see the only forseeable problem with this is that sheets that are preformatted to take pasted values (eg. via a macro) could lose their formatting.
Labels: Addin, Excel, File Size, Formatting
Wednesday, March 14, 2007
Cheap Office 2007 for Australian Uni Students
Copied from Nick Mayhew
It's Not Cheating - special promotion for uni students
What is itsnotcheating.com.au?
Approx. 1 million Australian students in 43 Australian universities will be able to purchase Office Ultimate 2007 online for AUD$75 outright or AUD$25 for one year (subscription) simply by providing their university email address for verification purposes.
How long?
The offer will run from Feb 26th – May 28th, we are also giving away a Vespa GT200, a Vista HP laptop, a Samsung mobile phone and one year FREE Sanity music downloads purely by submitting a blog on www.itsnotcheating.com.au
What do you get in Office Ultimate 2007?
· Microsoft Office Access 2007
· Microsoft Office Excel 2007
· Microsoft Office Groove 2007
· Microsoft Office InfoPath 2007
· Microsoft Office OneNote 2007
· Microsoft Office Outlook 2007 with Business Contact Manager
· Microsoft Office PowerPoint 2007
· Microsoft Office Publisher 2007
· Microsoft Office Word 2007
Ps. Tutors and alumnis can purchase too – as long as they have a university email address!
Labels: Office2007