Wrong data is saved to a spreadsheet / attachment

Question

Hi

I have a user who is experiencing funny problems with Office.

Office 2010 Standard

SharePoint 2010 Enterprise

The user will open the file from SharePoint, modify the data, save it back to a NEW file in SharePoint via a mapped drive.

The user will then close the file, open a new email and select "Attach file", browses to the mapped drive pointing to the SharePoint document library then attaches the file.

When she sends the file, the WRONG file is sent. The filename is correct, even the tab name at the bottom of the excel spreadsheet is correct, however the data in the cells is INCORRECT DATA from a different spreadsheet that the user worked on previously. 

The user is definitely saving the data correcty, but when you re-open the file the data is wrong... not even previous data that was in the spreadsheet before, but completely different data from a completely seperate spreadsheet.

This is happening on a frequent basis and is causing major problems as sensitive data is being sent accidently via email.

I have tried clearing all temp files and outlook security temp folder, but the problem still perisists.

I have upgraded the user from Office 2007 to Office 2010, but is still having the same problem.

Any ideas? Or has anyone experienced something similar?

Thanks

Leigh

Answer 1

Hi JY

Thanks for the feedback, I have checked permissions.

All my users have design rights (applied using Global Security groups).

I will try add the user individually with Full rights, but the user has not had any permission related issues, or saving errors.

Regards

Leigh

Answer 2

Hi,

I don't know if it is related, but it coulb be a user read/right priviledge problem (on sharepoint).

Excel savve as follow

OldXL.xls

save or save as => create ADGDDD (temp.xls)

If save is Ok ( check if corrupt or other problem ) then

rename and delete previous. (this is the problem area).

HTH

Regards

JY

Answer 3

Hi Deepa

Thanks for the reply!

We are using an Exchange 2010 email account.

When we save the file locally, then upload it to SharePoint or send it by email it does save the correct data.

The problem only seems to occur when you save the file directly to SharePoint via the mapped drive. I am going to post on the SharePoint forum today as well to see if they can perhaps help.

Today I am going to try give the user a new machine with a clean OS and Office install to see if the problem persists. There is only one user with this problem, if it continues to happen on a new machine I suspect it could be a problem with SharePoint.

My suspicions are that perhaps there may be a problem with the Outlook/Excel temp or cache folders that’s causing data corruption from other spread sheets. But I am not certain at all.

Thanks

Leigh

Answer 4

What is the type of emails account configured in Outlook? Is it POP/IMAP/Exchange?

Try saving the file locally and then modify the data. Once it’s done attach it to a mail and send it. Check if the issue occurs.

You may also post in the SharePoint forum:

http://social.msdn.microsoft.com/Forums/en/sharepointgeneral/threads