how can i secuire Sheet Same time Update the Pivot Table
 

DEAR SIR. I USED TO PREPARE SOME SHHETS INCLUDING PIVOT TABLES
THOSE SHEETS USUALLY USED BY MY FAMILY MEMBERS THE PROBLEM COME WHEN I
PROTECT THE SHEETS AND IN THE SAME TIME I NEED THE OTHERS TO OPEN THE SHEET
AND DO UPDATE EITHER BY DIRECT REFRESH THE PIVOT TABLES OR BY MACROS ATTACHED
TO THE FILE THAT MACRO UPDATE THE SHEET ..BUT I FOUND THAT UPDATING MACRO
CAN'T WORK OR REFRESH THE PIVOT TABLE THAT LOCTAED IN PROTECTED SHEET..SO
PLEASE HELP ME ..ALSO SHOW ME HOW I CAN CHANGE THE FORMAT OF BAHTTEXT
FUNCTION ..I TRIED SEVERAL TIMES IN THE REGIONAL SETTING BUT IT DOESN'T WORK
...PLEASE HELP ME