Patty's Avatar


03 Nov, 2010 09:23 PM


I am having problems in excel viewing the data. I pasted the content into the raw data field (i followed the video you have, very helpful)

Problem is I am on a Mac. Once I click on Start here it says :

The macro "OptimalSort-Analysis-Template.xls"!PopularCategorizeSheet' cannot be found.

Do you know how I can fix this? I never got a prompt to enable macro's. Googled it to death and cannnot find information for excel on a mac.



  1. 2 Posted by Evan on 03 Nov, 2010 09:53 PM

    Evan's Avatar

    Hi Patty,

    You'll see on the Downloads tab in OptimalSort that it currently says "You will need Excel on Windows to use the Macros," however this isn't strictly true anymore. Office 2011 for Mac supports macros and appears to work well with the spreadsheet. Earlier versions unfortunately do not work. I'll make sure we update that message on the Downloads tab.

    Hopefully the spreadsheet functionality (correlation scores based on standardised category labels) will make it into the OptimalSort web application itself some time in the near future. We have been planning it for a long time but have struggled to prioritize the development. Now that we have new versions of Chalkmark and Treejack released, it is something that we will take another look at shortly.

    In the mean time, hopefully you have a Windows PC nearby, or a Mac running Office 2011. Sorry for the inconvenience.


  2. Evan closed this discussion on 03 Nov, 2010 09:53 PM.

Comments are currently closed for this discussion. You can start a new one.

Keyboard shortcuts


? Show this help
ESC Blurs the current field

Comment Form

r Focus the comment reply box
^ + ↩ Submit the comment

You can use Command ⌘ instead of Control ^ on Mac