ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Shared workbook - to save or not to save (https://www.excelbanter.com/excel-discussion-misc-queries/117343-shared-workbook-save-not-save.html)

bluebird

Shared workbook - to save or not to save
 
I am having the same issues as other posts that were left plus additional
issues. I have a shared file saved on a common directory for multiple users
to access and make changes. We have eight groups that each have their own tab
to save changes. One group made all necessary changes on their tab and saved
the file. These changes were reviewed (or witnessed) by two or three users
on different workstations at different times - we know they were there. The
next day one user accessed the file again only to find some of the changes
remained and others were lost. There were two instances of this only the
instances involved different entries.

Another thing that is getting lost are formats. I post the original file
sometimes with columns or rows hidden that do not apply to what the users
need to update. However, occasionally when I open the file all hidden rows
and columns have been exploded on all eight tabs.

The shared file is a great tool; however, it is causing some to pull their
hair out.

Any help is greatly appreciated!

bluebird

Shared workbook - to save or not to save
 


"bluebird" wrote:

I am having the same issues as other posts that were left plus additional
issues. I have a shared file saved on a common directory for multiple users
to access and make changes. We have eight groups that each have their own tab
to save changes. One group made all necessary changes on their tab and saved
the file. These changes were reviewed (or witnessed) by two or three users
on different workstations at different times - we know they were there. The
next day one user accessed the file again only to find some of the changes
remained and others were lost. There were two instances of this only the
instances involved different entries.

Another thing that is getting lost are formats. I post the original file
sometimes with columns or rows hidden that do not apply to what the users
need to update. However, occasionally when I open the file all hidden rows
and columns have been exploded on all eight tabs.

The shared file is a great tool; however, it is causing some to pull their
hair out.

Any help is greatly appreciated!



All times are GMT +1. The time now is 10:44 PM.

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