Good day,

I have a number of excel workbooks that are being used by diffirent users on their own machines. These workbooks are all stored on a shared folder on a server. These workbooks contain sheets that have a couple of pivot tables (these are all hidden), the other sheets are for completion and population of data by each user.

I on the other hand have a workbook with a makro that opens these users workbooks and extracts data as and when I whish. It opens the users workbooks as read only and closes it without saving it. All works quite well, the templates are open with the users at all times and they just refresh, save, without closing their workbooks.

Now my problem, excel starts giving error messages to the users when they try to save, file is currently in use please try again later.... this causes data to be lost, because the user has to do a blunt shut down, although all excel documents are closed on their machines, excel.exe process is still running in the background and it cannot be stopped by selecting the end process function in the windows task bar.

Whilst using excel 2003 and 2007 with windows xp, we did not receive any problems. This only started when we upgraded a month ago to windows 7 and excel 2010.

Do you think it is an error in my macro or what can we do to fix this in excel/windows?

Thanx a mill, the users and myself is seriously thinking about rolling back to XP and excel 2007....