A limit on the length of a file name is fine, but limiting the file path length means that if your life is complicated by folders within folders then you regularly have to move around folders just to save documents in Excel. This is very tedious and creates new possibilities for error while working.8 votes
There is no simple means of selecting a file name from a VBA macro on the Mac platform. The only workaround devised (as far as I know) is incredibly clumsy and does not allow use of the GetFileName or ChDir routines.16 votes
Theis is related to the leading zeroes one, but it is at least as bothersome that it tries to format as an excel data anything that looks like a date -- including values that are not dates. And the date formatting means you can't use Excel to open a CSV with dates, edit it, and re-save it without completely changing the way dates are formatted.57 votes
Thanks for all the votes and comments for this suggestion. We are considering improvements to how Excel deals with reformatting (or not) as data is imported and entered from CSV and other sources. Your comments are very helpful.
Steve K [MS Excel]
- Don't see your idea?