excel on mac
 

  You don't need to be an 'investor' to invest in Singletrack: 6 days left: 95% of target - Find out more

[Closed] excel on mac

8 Posts
7 Users
0 Reactions
63 Views
Posts: 0
Free Member
Topic starter
 

i have office for mac

trying to sort spreadsheet of business prospects and when i organise as a list, the whole mac grinds to a halt. i can turn the data into a list but then when i try and sort, it all freezes??? its about 1000 rows but needs to add another 2000

any ideas other than buy a PC?

ta


 
Posted : 12/09/2010 9:11 pm
 mrmo
Posts: 10687
Free Member
 

more ram.


 
Posted : 12/09/2010 9:18 pm
Posts: 0
Free Member
 

Use Mac's own app, 'Numbers'* instead. Much, much nicer and easier to use. Works the same way, and files can be saved in Excel formats. Can open Excel files.

*Part of iWork package. Like Office, but it 'just works'.

****ing Microshite.


 
Posted : 12/09/2010 9:21 pm
Posts: 91000
Free Member
 

Excel is terrible at sorting data.. does this help?


 
Posted : 12/09/2010 9:21 pm
Posts: 0
Free Member
Topic starter
 

iHave 4 gig ram

iWill try and steal iWork

iThank you all


 
Posted : 12/09/2010 9:25 pm
 mrmo
Posts: 10687
Free Member
 

just a thought, are you using 2008? if so it is crap 2004 is quicker, it is to do with the coding and being a bodge job. Hopefully the nest version 2011/12 will be better and it meant to be getting VBA back again. Hopefully it will work with Windows Excel VBA, unlike previous versions.


 
Posted : 12/09/2010 9:33 pm
Posts: 0
Free Member
 

3,000 rows doesn't sound very much to sort unless you have alot of columns. It may be worthwhile deleting all rows below your last bit of data. If you have rubbish in rows after end of your data then excel can end up trying to sort alot more rows than you think.


 
Posted : 12/09/2010 10:04 pm
Posts: 0
Free Member
 

Is Open Office an option?


 
Posted : 12/09/2010 10:44 pm
Posts: 0
Free Member
 

numbers from the iwork package, the templates you will see will blow your mind !

3 apps that do all that microsh1tes 4 jobs and with a lot more functionality


 
Posted : 13/09/2010 6:48 am

6 DAYS LEFT
We are currently at 95% of our target!