Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
ACH
 
Posts: n/a
Default Problem with shared workbook (history sheet)

My colleagues and I have been working in a shared workbook for weeks. Each
day we add a new spreadsheet, rename it with the day's date, and make
comments. The file is set to highlight changes by other users on the screen
when you save your changes (not set to list changes on a new sheet, i.e.,
history sheet). No changes have been made to these settings. When I went to
insert a new worksheet today and rename it with today's date, a box popped up
that says "History sheet cannot be renamed." Why is this happening? We
haven't had any trouble up until today. Would it have anything to do with
the size of the file? I have had this happen before with a different
workbook. I added one sheet that could not be renamed. When I added a
second sheet, the first one disappeared and I was able to rename the second,
but then we had problems sharing the file and saving data at the same time.
Things were saving on the wrong tab of the workbook and overwriting other
data, thus I'm hesitant to attempt the same fix with this workbook. Thanks
for your help!
  #2   Report Post  
Frank Kabel
 
Posts: n/a
Default

Hi
not a solution bt shared workbooks are IMHO known for such bus. I think this
feature is just not stable in Excel!

"ACH" wrote:

My colleagues and I have been working in a shared workbook for weeks. Each
day we add a new spreadsheet, rename it with the day's date, and make
comments. The file is set to highlight changes by other users on the screen
when you save your changes (not set to list changes on a new sheet, i.e.,
history sheet). No changes have been made to these settings. When I went to
insert a new worksheet today and rename it with today's date, a box popped up
that says "History sheet cannot be renamed." Why is this happening? We
haven't had any trouble up until today. Would it have anything to do with
the size of the file? I have had this happen before with a different
workbook. I added one sheet that could not be renamed. When I added a
second sheet, the first one disappeared and I was able to rename the second,
but then we had problems sharing the file and saving data at the same time.
Things were saving on the wrong tab of the workbook and overwriting other
data, thus I'm hesitant to attempt the same fix with this workbook. Thanks
for your help!

  #3   Report Post  
RosieToes2004
 
Posts: n/a
Default

We've had a lot of problems here too, with a shared workbook. I have a
workbook with about 30 tabs in it (file is about 4 megs-not that large) and
I've sat and watched tabs just "disappear" during the saving process. I
agree with Frank's post that the shared function is extremely unstable.


"ACH" wrote:

My colleagues and I have been working in a shared workbook for weeks. Each
day we add a new spreadsheet, rename it with the day's date, and make
comments. The file is set to highlight changes by other users on the screen
when you save your changes (not set to list changes on a new sheet, i.e.,
history sheet). No changes have been made to these settings. When I went to
insert a new worksheet today and rename it with today's date, a box popped up
that says "History sheet cannot be renamed." Why is this happening? We
haven't had any trouble up until today. Would it have anything to do with
the size of the file? I have had this happen before with a different
workbook. I added one sheet that could not be renamed. When I added a
second sheet, the first one disappeared and I was able to rename the second,
but then we had problems sharing the file and saving data at the same time.
Things were saving on the wrong tab of the workbook and overwriting other
data, thus I'm hesitant to attempt the same fix with this workbook. Thanks
for your help!

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Linking sheets to a summary sheet in workbook gambinijr Excel Discussion (Misc queries) 4 December 16th 04 09:13 PM
Shared workbook protection zeek Excel Discussion (Misc queries) 1 December 13th 04 02:30 PM
Stubborn toolbars in Excel 007 Excel Discussion (Misc queries) 9 December 11th 04 03:02 PM
Scroll Bar in Shared workbook Ronil Patel Excel Discussion (Misc queries) 2 December 8th 04 02:49 AM
Naming & renaming a sheet tab Cgbilliar Excel Worksheet Functions 1 November 7th 04 06:57 PM


All times are GMT +1. The time now is 12:49 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"