Yeah, see a lot of .xlr, don't get it.
They do open, but if I e mail it to others they can't open it.
That's how this was discovered.
I see about 30 files. Maybe an intern worked on it as some point, but still??
Hi Kevs,
Based on what you said, it sounds like someone saved files that are
really xls but manually overrode the extension with xlr.
If that's the case there's a few ways to fix this.
One way is to go into Finder and manually change the last letter from r to s
If you have thousands of these files you might be able to write an
AppleScript that goes through your directories, searches for file
extensions of xlr and replaces them with xls. But if you only have a few
doing it manually makes more sense.
Another way is to use File > Open in Excel to open the xlr files, then
File Save As and make sure that the file type is Microsoft Excel and
that the extension is xls.
-Jim
--
Jim Gordon
Mac MVP
WE NEED YOUR HELP!
The number of new Mac users has skyrocketed. That’s excellent. In this
forum all answers come from other users, not from Microsoft employees.
Please help answer questions.
If you see an unanswered question that you know the answer to, please
take just a moment to post the answer. Doing so speeds response time for
people who come here and need fast responses.
If you see an answer that might be wrong or that you can answer better,
hop right in and offer your thoughts. Don’t berate a wrong answer –
we’re all here trying to help each other.
Don’t bother with questions you’re not quite sure about or don’t know about.
Please take just a moment to help fellow Mac users. Your efforts will be
appreciated greatly - especially by those you help.
