Excel 2003, Auto Filter Help!
I have a 21,000 row XML file that I pull into Excel every morning:
Data / Import Data / Select Data Source / OK ...and all is well ....until I updated to a new PC and had to reload Excel. Now I get autofilters at the top of each column, and it won't load all the data. I know I can go in AFTER I load and uncheck Data / filter / autofilter and it will remove the filter queues on the top row, but I DON'T know how to set up an option where it will not format with auto filters from the get-go. ...so I can load this data completely. What am I missing here?! Thanks! - Hu - |
All times are GMT +1. The time now is 04:01 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com