| Forum Home | ||||
| Press F1 | ||||
| Thread ID: 120046 | 2011-08-23 03:01:00 | Excel help | zqia014 (13726) | Press F1 |
| Post ID | Timestamp | Content | User | ||
| 1225293 | 2011-08-23 03:01:00 | Hi all, I'm importing a lot of .csv files into Excel. They are set to automatically update themselves every 1 minute. Excel always has default refresh rate at 60 minutes, found under Data/Connections/Properties, after I've imported the data. Is there a way to make this default 1 minute? So I don't have to change it all the time? Please see the picture and you'll know what I mean. Thanks for any advice. |
zqia014 (13726) | ||
| 1225294 | 2011-08-23 04:07:00 | The answer is right there in fornt of you. The bit in the image you circled - set it to one minute... or am I missing some restriction in the software? You'll need to put a tick in the box to the left, then put a 1 in the box on the right |
Paul.Cov (425) | ||
| 1225295 | 2011-08-23 05:50:00 | What I'm trying to achieve is that instead of me manually putting in 1 minute, I would like Excel to have 1 minute as a default, so I only have to tick the box. Sounds a little lazy I know, but there are lots and lots of sheets I have to do this for. Cheers |
zqia014 (13726) | ||
| 1225296 | 2011-08-23 10:08:00 | There's probably a registry hack to do what you want, but I don't have the answer you want. | Paul.Cov (425) | ||
| 1 | |||||