I am on a Network at work, and decided it was getting to be a pain in the butt, everytime I needed to add something to a workbook that several users access and I was always given a 'workbook looked by Bob, open read only?' I decided to make the workbook shared. This way everyone who needed too, could access the workbook and add, edit etc. It was working great. Then my friend started having problems with Excel. It would freeze, then repair itself. But after it was repaired, all the formatting was lost etc.
Has anyone experienced this?
We have only tried the 'shared' thing for a day, but it will serve as a great advancement for our team and I don't want to have to put things back to the way they were. This way will save considerable time for everyone who needs to use the same book.