How to disable automatic refresh

**jiminy** · 06-29-2010, 05:25 AM

Hi,

I have a spreadsheet which automatically refreshes against external data. I want to send this spreadsheet out on a regualr basis to various people but how do I not give them the option to refresh the data as it has been done at my end? It also slows down the spreadsheet opening at their end, so I would like to remove the option altogether.

Many thanks
Scott

**dominicb** · 06-29-2010, 05:35 AM

Good morning jiminy

…and welcome to the forum!!

You need to go to Edit > Links, Startup Prompt and select “Dont display alerts and don’t update links”.

HTH

DominicB,

**jiminy** · 06-30-2010, 04:28 AM

Hi Dominic,

Many thanks for replying to my query and for welcoming me to the forum. What I was looking for was to refresh the spreadsheet every week against external data, then send it out to recipients without them having the ability to refresh the data.

I would prefer it not to be a manual process and my links option is greyed out anyway.

Can you help further please?

Many thanks
Scott

**dominicb** · 06-30-2010, 07:07 AM

Hi jiminy

Originally Posted by jiminy

I would prefer it not to be a manual process and my links option is greyed out anyway.

If your Links option is greyed out, then you are not linking to an external wotkbook.
As you have neglected to say so far, you might want to clarify exactly what external source you are linking to and how.

DominicB

**jiminy** · 07-01-2010, 03:55 AM

Hi Dominic,

It is data imported from a company database. Every time I open the spreadsheet, I get a dialog box asking me to Enable automatic refresh or disable it. I want to refresh it at my end, so I click enable. Once I've amended it, I then want to email it to some recipients.

Where my problem lies is that I don't want those users having the ability to refresh the data and was wondering how I could prevent them from doing so. Would this require a macro, and if so, could you give me a starter for ten please.

Many thanks
Scott

**dominicb** · 07-01-2010, 04:29 AM

Hi jiminy

I don't know exactly how your workbook is setup, so we'll try this, but first of all CREATE A COPY OF YOUR WORKBOOK - DO NOT USE THE ORIGINAL.

Now, open the copy and when you are asked the question, select disable. Then when you open the file in future, neither you, or anyone else should get asked the question.

However, you can force an update by going to Data > Refresh Data.

HTH

DominicB