I just want to sort the data in one existing XL workbook (not in all of XL and not in all of Office 2010) using the Swedish language character set (I believe it's character set=ISO8859_1). Compared to English, Swedish has two additional forms of A and one additional form of O, which sort at the end of the alphabet, not with the other forms of A and O. Excel (English (U.S>.)) ignores the diacriticals and sorts them as either A or O.
I don't want to change my keyboard, and I'm not particularly bothered by the proofing errors these letters create.
I've purchased the Swedish language pack, and opened the .exe file (OfficeLangPack_Swedish_x64.exe). Unfortunately, the next thing I saw was a fairly long note in Swedish - which I don't understand beyond a few genealogy tems and some politenesses I learned as a child. But there was an OK button, so I clicked on that. After that - nothing. Don't know if it installed or not. I checked in Excel/options/language where it only shows English enabled and installed. I tried adding Swedish there, and it comes up "not enabled" and "not installed".
So what do I need to do to get sorting in Swedish?