Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Shared Workbooks-shared headers and footers
My question is revolved around using shared workbooks being updated by
different users. It seems that each person is having to setup the formats, page setup, individually. If this workbook is being saved in a shared drive, why can't the first person that saves these specifics, save for each. Is there some setting that is not updated properly in the workbook? |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Shared Workbooks-shared headers and footers
Since no one answered this question, I will add what I think I have learned.
Under Tools/Shared Workbooks/Advanced tab. Bottom of this tab 'In personal view". This setting is defaulted as flagged as personal settings and filters, which means each person has to set their personal settings and filters. If you clear these settings, the owner of the workbook can set the headers/footers, autofilters, etc for the group. "Sherry" wrote: My question is revolved around using shared workbooks being updated by different users. It seems that each person is having to setup the formats, page setup, individually. If this workbook is being saved in a shared drive, why can't the first person that saves these specifics, save for each. Is there some setting that is not updated properly in the workbook? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Issues with shared vs. non-shared formulas on somewhat wide spreadsheets | Excel Discussion (Misc queries) | |||
Printing viewing a shared workbook on a shared drive | Excel Discussion (Misc queries) | |||
How do I copy headers/footers to multiple different workbooks? | Excel Discussion (Misc queries) | |||
Headers and Footers Accros Workbooks | Excel Discussion (Misc queries) | |||
Headers on a Shared Workbook | Excel Discussion (Misc queries) |