Tag Info

Hot answers tagged


I figured it out, almost by accident. You see how in the original screenshot, the row colors alternate but then stop at row 23. That's because the "table" part of the worksheet only included the top rows, and the filtering only works on those rows. I had to reformat ALL of my data as a table, and now it works. This is really non-obvious.


After some investigation and no other answers, the answer seems to be the latest version of Word .docx. I opened an old file and saved it as .docx and it opened on Word Online without conversion. For those of you interested in the code. If you are converting files you need to use the new SaveAs2 function on the document in VBA for the compatibility ...


Wikipedia has a fairly neat comparison of all the various editions and features.

Only top voted, non community-wiki answers of a minimum length are eligible