| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Querytable refreshing on a protected spreadsheet
How do I allow a querytable to refresh while the spreadsheet is protected?
|
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Querytable refreshing on a protected spreadsheet
CDC
You have to refresh it in code. I haven't found a way to refresh it without first unprotecting the sheet. Sheet1.Unprotect Sheet1.QueryTables(1).Refresh False Sheet1.Protect -- Dick Kusleika Excel MVP Daily Dose of Excel www.dicks-blog.com CDConsultant wrote: How do I allow a querytable to refresh while the spreadsheet is protected? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Refreshing ODBC data on Protected Sheets | Excel Discussion (Misc queries) | |||
| Refreshing Pivot Table on a protected spreadsheet tab | Excel Discussion (Misc queries) | |||
| Partially refreshing spreadsheet | Excel Worksheet Functions | |||
| Refreshing an Excel spreadsheet | Excel Programming | |||
| Refreshing an external query on a protected sheet | Excel Programming | |||
Linear Mode
