G
Gunder
I have a shared workbook upgraded from Excel 2003 to Excel 2007 (saved as
2007 format). Both run in an ASP environment. The Excel 2003 OS was Windows
2003 server while Excel 2007 is running on Windows 2008 server.
The workbook itself is about pipeline data and each salesman updates his
rows. The registration worksheet as filter enabled so that each salesman can
see only his rows, sort them as he pleases and so on. The sorting
possibilities in filter in 2007 are much better than in 2003 (even in shared
mode). The problem after upgrading is that the rows keep mixing together,
this means that data from one row suddenly is on another row. It seems like
that when one salesman changes the sorting, Excel is not keeping track of the
different sorting so that other salesmen updating at the same time are
writing data in other rows than they intended.
Has anybody experienced anything like this? Is there a workaround? Are there
limitations to sorting with filters in shared work books?
Thanks in advance!
2007 format). Both run in an ASP environment. The Excel 2003 OS was Windows
2003 server while Excel 2007 is running on Windows 2008 server.
The workbook itself is about pipeline data and each salesman updates his
rows. The registration worksheet as filter enabled so that each salesman can
see only his rows, sort them as he pleases and so on. The sorting
possibilities in filter in 2007 are much better than in 2003 (even in shared
mode). The problem after upgrading is that the rows keep mixing together,
this means that data from one row suddenly is on another row. It seems like
that when one salesman changes the sorting, Excel is not keeping track of the
different sorting so that other salesmen updating at the same time are
writing data in other rows than they intended.
Has anybody experienced anything like this? Is there a workaround? Are there
limitations to sorting with filters in shared work books?
Thanks in advance!