Share the Workbook
http://www.ozgrid.com/Excel/track-changes.htm



--
Regards
Dave Hawley
www.ozgrid.com
"bham" wrote in message
...
Hello,

I have an excel file with a large amount of data that i need to make
accessible to a large number of users in the office. There are also a
couple
of people who need to be able to edit this file to make changes.

The porblem that we have at the moment is that those who only need read
only
access are currently locking the file from being edited if they open it
1st.

I thought the solution might be to copy the data into a separate readable
workbook using copy - paste special - link which i did by highlighting
the
entire range of rows.

When i paste this into a new doc the file size becomes huge.
Original doc: 639kb
Linked doc: 297,503 kb

Is there a more efficient way to link an entire worksheet than selecting
rows?

Or is there another way all together to fix the problem of read only
people
locking the file from the editors?

Thanks