Unable to filter and cels copy information from other tabs

[JCHuysamer]

Hi all

I have a bit of a wierd problem

I have saved a spreadsheet on our server as a shared workbook that gets populated from a userform on my(or the other users desktop)
The macro opens the workbook on the server, copys in the info from the userform into the "Master Data File", saves the workbook and closes the file.

But if i open the "Data Master File" and edit info on any sheet and/or cell that data is copied to all sheets (same cell) but there are no links that bind the cells ???????????????
i also cant add or clear the filter on the sheet.

when i open the workbook on the server ("Data Master File") the filename at the top is displayed followed by [Group] [Shared] - i know the workbook must be shared but how/what is the group for and how do i remove it.

 

[Fishboy]

Hi all

I have a bit of a wierd problem

I have saved a spreadsheet on our server as a shared workbook that gets populated from a userform on my(or the other users desktop)
The macro opens the workbook on the server, copys in the info from the userform into the "Master Data File", saves the workbook and closes the file.

But if i open the "Data Master File" and edit info on any sheet and/or cell that data is copied to all sheets (same cell) but there are no links that bind the cells ???????????????
i also cant add or clear the filter on the sheet.

when i open the workbook on the server ("Data Master File") the filename at the top is displayed followed by [Group] [Shared] - i know the workbook must be shared but how/what is the group for and how do i remove it.

Hi JCHuysamer,

Is there any code hidden behind the sheets, or at ThisWorkbook level?

 

[JCHuysamer]

hi

Thanks - got it figured out - more than 1 worksheet was selected and this coased all the problems aswell as the [Group] at the top of the the page

 

[Fishboy]

hi

Thanks - got it figured out - more than 1 worksheet was selected and this coased all the problems aswell as the [Group] at the top of the the page

Glad to hear that you got it sorted