anonymous

Good morning, I am trying to get data from an excel file saved on Sharepoint, but I get the error message 'We couldn't authenticate with the credentials provided' when trying to connect anonymously. I am using Office 365. Does anyone know how to grant anonymous access? Many thanks, Paul

Hi All, I want to create an excel file on a network drive so multiple people can edit and add information however I want it to remain anonymous so I don't want excel to show the username of the person currently editing it when someone else opens the file at the same time. Is there anyway...

Hi, I have a basic spreadsheet with 4 columns of data: Column A contains a date Column D contains a numeric value I want to run a macro/query that outputs the total numeric values for any given date. e.g. <colgroup><col><col span="2"><col></colgroup><tbody> Week Commencing Name...

I have a question I'm sure is child's play to you guys. I have a column of users logins and I need to make them anonymous. It's a rather large list, and I'll be repeating this many times, so I'd like to create a macro to do it. Column of names A johnr billm mattv desired outcome...