Forum

Yes, you can set up slicers and filters and what one user does will not affect what another user sees.

I know you can read/write data in Sharepoint lists using ADO, but I'm not sure if that will work to an Excel file data source on SP/OD. If I find some...

It would depend somewhat on the circumstances. I was thinking ADO, though I'm not sure how well that will work with Sharepoint as a back-end file loca...

Why do the users have to have their own individual files, rather than writing to one central file (or database, or List)? It's making everything a lot...

I'd guess that was the Title column, which is a system column. You cannot change its data type, nor can you delete it.

You've got manual formatting applied to some cells (eg a light blue fill on the Jan sheet). You should remove that.

Try something like this: Sub data() Dim ws_Form As Worksheet Set ws_Form = Sheets("Form") Dim ws_Data As Worksheet Set ws_Data = Sheets("Data") Dim...

If you change cells in a Change event, you should always disable events while you do so to avoid recursion: Private Sub Worksheet_Change(ByVal Targ...

Using the IMAGE function is not the same as inserting a picture on a sheet. You cannot select or name the picture as it is a function result, not a sh...

Custom ribbons don't work for hidden normal workbooks (i.e. that don't have the IsAddin property set to True).

Not really, no.

I don't think you can link them. You can copy and paste the image from the sheet to use as the picture fill for a data point, but it's static. You cou...

My suspicion would be that this code is not the cause of the problem. It could only delete the file when you run it, and it will only delete the file ...

I can't see anything wrong with the revised code (though I'm surprised you're saving it locally given what you describe) - if the file failed to save ...

I disagree. It will not work properly in a UDF - Microsoft even states that in the documentation.