Disable External Data Refresh

Puforee · #1 03-06-2018, 09:45 AM

I have a spreadsheet fed by a MS Access DB that I refresh monthly. I have saved a copy of the spreadsheet to another place where access is controlled. But, I don't want the users to do Data - Refreshes. How can I turn this off?

NBVC · #2 03-06-2018, 11:14 AM

If you go to Data|Properties for the table, you should see a checkbox to allow you to disable refresh.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Help with plotting new chart after every data refresh	ebutu555	Excel	2	08-27-2017 11:37 PM
Embedded Excel charts refresh only data values, not which data points (rows) are included	GregL	Word	0	12-01-2016 10:24 AM
Automatically refresh data	maestro1	Visio	0	03-07-2016 05:36 AM
Excelchart in Visio, refresh data	sffranz	Visio	0	02-18-2016 09:13 AM
Refresh of data from external source	Jirik61	Excel Programming	3	07-13-2012 01:40 PM