Shared workbook-header not working
in [General]
|
From: Mary jane on 5 Feb 2010 10:22 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
From: Dave Peterson on 5 Feb 2010 10:29 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
From: Mary jane on 9 Feb 2010 11:02 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
From: Dave Peterson on 9 Feb 2010 11:16 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
From: Mary jane on 9 Feb 2010 14:17 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
|
Pages: 1 Prev: Place numbers in ascending order Next: Column vs Row Size Ratio? |