We are using web services interface to access Excel Services.
When we have two sessions that access the same spreadsheet, it looks like they see each others data.
Is this how it is supposed to work? Should they not get their own copy of the spreadsheet?
An example: loan calculation spreadsheet
- User A opens spreadsheet sets loan amount to 100
- User B opens spreadsheet sets loan amount to 200
- User A gets the monthly payment
I expect that user A will get a monthly payment based on 100 since he is working on his copy of the spreadsheet.