PDA

View Full Version : Excel help



zqia014
23-08-2011, 03:01 PM
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.

Paul.Cov
23-08-2011, 04:07 PM
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

zqia014
23-08-2011, 05:50 PM
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

Paul.Cov
23-08-2011, 10:08 PM
There's probably a registry hack to do what you want, but I don't have the answer you want.