It is currently Thu Mar 28, 2024 10:10 am

All times are UTC




Post new topic Reply to topic  [ 1 post ] 
Author Message
PostPosted: Tue Sep 14, 2010 12:05 pm 
Offline
Site Admin

Joined: Thu Jul 01, 2010 9:06 am
Posts: 175
How to use protected sheets with gauges alerts?

Microsoft Excel allows you to protect your workbook. There are two solutions:
  • by protecting your entire workbook
  • by protecting one or several worksheet(s)

Currently, only the second option may cause trouble with BeGraphic's gauges, especially with alerts.

If you meet the next message:
Image

Please follow this procedure (after having deprotected your worksheet):

If you are using Excel 2007 or 2010:
  • Go to the 'Review' menu in the Excel ribbon
  • Select 'Protect worksheet'
    Image
  • Check the 'Edit objects' option
    Image
  • Select each gauge and click on the 'Set parameters' button in the BeGraphic's ribbon and directly click on 'Validate'. This
    This action will update the gauge
Image


If you are using Excel 2003:
  • Go to the 'Tools' menu in the Excel ribbon, then 'Protection' and finally 'Protect Sheet'
    Image
  • Check the 'Edit objects' option.
    Image
  • Select each gauge, then right click and 'Set parameters'. Directly click on 'Validate All'.
    This action will update the gauge


The BeGraphic Team


Top
 Profile Send private message  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 1 post ] 

All times are UTC


Who is online

Users browsing this forum: No registered users and 7 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  
cron
Powered by phpBB® Forum Software © phpBB Group