doicomehereoften1
New Member
- Joined
- Feb 7, 2008
- Messages
- 31
With the latest update for Excel loaded (it just got installed today), when opening a .txt file by selecting it and choosing Open With>Excel, it is now automatically putting it the data into columns which really screws up all the macros that format the data into usable reports. I found a sort-of fix by having Excel already open, going to FILE>OPEN, then choosing the .txt file and holding down SHIFT while clicking OPEN but I the way I've taught the other staff to run these macros is to use the Open With method since it's easier.
Does anybody know how to turn this "Feature" off? I haven't been able to find anything else about it thus far.
Does anybody know how to turn this "Feature" off? I haven't been able to find anything else about it thus far.