|
Post by wierdostomps on Jun 15, 2010 14:05:34 GMT
A colleague recently tried to email me an Excel Workbook. Now, admittedly it had about 10 worksheets and contained links to various external sources, but the file was over 13Mb in size.
After I stripped out all the logos (which he had pasted in twice to every page) it was still 4.1Mb.
I exported it to Excel 2008, which reduced it to 1.3Mb, but that still seemed excessive, so I opened it in Numbers.
I got a strange warning that Numbers does not support hidden sheets and that they had been made visible.
And lo and behold, there were two additional sheets visible in Numbers that had not been there in Excel - containing an Income and Expense report and the entire cashbook ledger from his previous employer!!!
It appears that he had used a previous template, believing he had deleted all the actual data - but Excel, in its wisdom, had retained all the autosave data from previous versions - giving me full access to his previous employer's accounts!
I have heard of Office's bad practice in retaining data before, but had never realised the scale or seriousness of the problem.
|
|
|
Post by Alex on Jun 15, 2010 15:37:25 GMT
Ahhh...
Excel, you suck so much. I hate you almost as much as Microsoft Access. Evil programs.
|
|
|
Post by Forum Cat on Jun 15, 2010 15:48:53 GMT
I have always thought of Excel as being the jewel in Microsoft's crown. The best spreadsheet app in the world by far. It may not be perfect but it makes Numbers look very basic by comparison.
|
|
|
Post by wierdostomps on Jun 15, 2010 15:53:43 GMT
I agree - Numbers is pretty, but when it comes to sheer crunching power, you can't beat Excel.
Incidentally, I have now found out how my colleague should have deleted the data. It looks as though the sheets were hidden - so by unhiding them from the Format - sheet - menu, they could then have been deleted. But even so...
|
|
sjbuchanan007
Senior Member
Husband, father, Sports Fan, Apple Hardware Enthusiast
Posts: 238
|
Post by sjbuchanan007 on Jun 15, 2010 19:39:54 GMT
I also agree excel's features are second to none, I like the look of numbers but there are so many functions missing. Numbers is handy for taking a look at password protected excel files as it strips the protection out. However, I do prefer pages to word. I recently created some psters for work, they were to be printed on A1 paper, word can't handle pages this large, yet pages handled it superbly. I know pages is no substitute for a proper DTP package, but funds can't permit indesign or quark for how often I would use it, but it does pretty well. I'll post a link to them when I go back on my iMac. clicky
|
|
|
Post by wierdostomps on Jun 16, 2010 15:04:17 GMT
The one reason I keep Word on my laptop is because Pages is even worse in the way it handles tables. In particular, its inability to break a table across a page - and the unpredictable way it imports tables from Word files.
I have also had comments from PC using colleagues that they can sometimes not open the Word files generated by Pages - particularly on older machines. While I am sure this is a Microsoft issue, it is severe enough that I have reluctantly gone back to using Word as my default and only using Pages on Mac only documents.
|
|
|
Post by beerbum on Jun 16, 2010 15:44:24 GMT
I know pages is no substitute for a proper DTP package, but funds can't permit indesign or quark for how often I would use it, but it does pretty well. I'll post a link to them when I go back on my iMac. clickyImpressive posters from Pages
|
|