Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Troubleshooting shared workbook in Excel 2007
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2007 Shared Workbook | Excel Discussion (Misc queries) | |||
Shared Excel 2007 Workbook Print Setting | Excel Discussion (Misc queries) | |||
ACCESSING A SHARED EXCEL 2003 WORKBOOK ISSUES WITH OFFICE 2007 | Excel Discussion (Misc queries) | |||
Excel Shared Spreadsheet Troubleshooting | Excel Worksheet Functions | |||
Excel 2007 Shared Workbook Saved changes not applied correctly | Excel Discussion (Misc queries) |