Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 11
Default Refreshing ODBC data on Protected Sheets

Hi Guys,

My skill with excel doesnt go much past basic formulas, so please excuse me
if this is a silly question.

My situation is as follows. (Excel 2007)

I have an excel workbook with 6 sheets which i would like to protect so
nothing can be modified (except filtering). Each sheet is populated by an
ODBC query which is refreshed when the file is opened. The problem is that
this is not allowed if the sheets are protected.

Any help would be appreciated. Also try to pretend you are talking to a 5
year old kid when you answer.....

Cheers

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Refreshing Pivot Table on a protected spreadsheet tab EarlyBirdie Excel Discussion (Misc queries) 1 July 5th 09 07:31 AM
Need help with refreshing data Cam Excel Discussion (Misc queries) 0 April 15th 08 07:12 PM
Prevent certain tabs/sheets from refreshing [email protected] Excel Discussion (Misc queries) 1 February 8th 07 02:11 PM
Sorting data in protected sheets? Arsenio Oloroso Excel Discussion (Misc queries) 1 December 30th 06 08:54 PM
Allowing data entry in protected sheets David Excel Discussion (Misc queries) 1 November 7th 06 09:18 PM


All times are GMT +1. The time now is 11:04 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"