The PQ loops through files in a folder. Users add cases to their files and the main PQ then gets updated. I am surprised we can't have files open to r...
Hi Matt, Thanks for your reply. It will be used by various clients; some have 365 and some don't, unfortunately. I think I've figured it out ...
I have been working on this and am slowly getting there. The issue that is causing the main problem is that User 1 may input a case initially, but ...
I'm also learning about Sheet View in SP/OD. Maybe I can somehow set the default to be the view where sorting and filtering is only seen by th...
SharePoint Lists seem to be very interesting. I'm just learning about them now, so my apologies if my next question seems ignorant. In my Excel fil...
That's very interesting and very good to know. I will check on this. So, it's different from Power Query in this way?
Hello, I don't know what ADO is, unfortunately. Basically, I will want pivot tables and charts based on the main data. When the file is accessed...
Hi there, They want the interface for each user to be Excel. This is done easily with VBA forms I designed. They click a button and the form popula...
Velouria, You have me thinking... If I understand correctly, the user should fill in the form that checks fields, creates a PDF, etc. then inste...
Hello, Thank you for your response. How would they do that? Do you mean they go directly into the SharePoint/OneDrive PQ file? If so, it wo...