When I close a spreadsheet, it is the size I want it to be. But when I reopen it, Excel is as likely as not to have "decided" that it knows better than I do what I want, and it reopens in a different size. Sorry, but I do know better than Excel does what I want, and resent the arrogance displayed in changing my preferences. Make it stop!!!44 votes
When you say that it opens a different size – can you give more info? Do you mean the application window is a different size (it shouldn’t be) or that the font sizes (zoom) are different? (again, they shouldn’t be)
Additionally, if you can post a video of what you’re seeing, that would be a big help for us.
If there is a problem here, it’s definitely something we’d want to fix.
Add a setting called
"Open text-delimited files (CSV, etc) as text only, with no type inference."
When this setting is active, then every column's format will be "Text" when a CSV or other such file is opened, so that the initial view is exactly the text represented in the CSV.59 votes
Thanks for the feedback!
Can you comment on whether you expect this to basically import all the lines as text to column A, or if you have some other expectation?
Also, I’m assuming people refer here to the file/open path, and not to the Data/From-Text or New-Query/From-Text path.
We need more information for this to be actionable.
- Don't see your idea?