| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
[Excel] How do I change the default import external data settings.
I need to change the default settings for importing .csv files into Excel so
that I don't have to change the settings every time I do the action. Is this possible? Many thanks to anyone who can help me!!! |
|
#2
|
|||
|
|||
|
Maybe you could rename the .csv file to .txt and record a macro when you do it
once. Then just rerun that macro the next time you need to import that file. (Keep recording while you add headers/footers/filters/etc and make it really useful.) djr wrote: I need to change the default settings for importing .csv files into Excel so that I don't have to change the settings every time I do the action. Is this possible? Many thanks to anyone who can help me!!! -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Import external data function | Excel Discussion (Misc queries) | |||
| How can I check if data in external data range is changed after re | Excel Discussion (Misc queries) | |||
| Fetching External Data from Excel | Excel Discussion (Misc queries) | |||
| Charting data ranges that change | Charts and Charting in Excel | |||
| How do I change the default settings in charts? | Charts and Charting in Excel | |||
Linear Mode
