ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Shared workbook-header not working (https://www.excelbanter.com/excel-discussion-misc-queries/255451-shared-workbook-header-not-working.html)

Mary jane

Shared workbook-header not working
 
I have a shared workbook in which the header holds the date. When changing
months, the headers work for me but no one else sharing! Should I turn off
sharing, change headers, then turn back on? I cannot find a setting to fix
this
Thanks

Dave Peterson

Shared workbook-header not working
 
Did you save the file after you made the change?

In the xl2003 share dialog (tools|share workbook), there's an advanced tab that
you can tell excel when to see the changes made by others.

What do you have that set for?

Mary jane wrote:

I have a shared workbook in which the header holds the date. When changing
months, the headers work for me but no one else sharing! Should I turn off
sharing, change headers, then turn back on? I cannot find a setting to fix
this
Thanks


--

Dave Peterson

Mary jane

Shared workbook-header not working
 
Hi Dave,
Yes I saved it, more then once. The setting is set for Ask me which changes
win.

"Mary jane" wrote:

I have a shared workbook in which the header holds the date. When changing
months, the headers work for me but no one else sharing! Should I turn off
sharing, change headers, then turn back on? I cannot find a setting to fix
this
Thanks


Dave Peterson

Shared workbook-header not working
 
I don't have a guess why the values change.

Mary jane wrote:

Hi Dave,
Yes I saved it, more then once. The setting is set for Ask me which changes
win.

"Mary jane" wrote:

I have a shared workbook in which the header holds the date. When changing
months, the headers work for me but no one else sharing! Should I turn off
sharing, change headers, then turn back on? I cannot find a setting to fix
this
Thanks


--

Dave Peterson

Mary jane

Shared workbook-header not working
 
Well the thing is they don't. I change them in the workbook and other users
open it up, review the headers and they are NOT changed, it is bizarre.

"Mary jane" wrote:

I have a shared workbook in which the header holds the date. When changing
months, the headers work for me but no one else sharing! Should I turn off
sharing, change headers, then turn back on? I cannot find a setting to fix
this
Thanks



All times are GMT +1. The time now is 07:16 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com