I'm creating a dashboard in Excel that watches an different excel spreadsheet we use for data entry. It's important that i avoid locking the spreadsheet out, I first tried using the workbook connections however it locks the spreadsheet so it cant be edited it is even set up a shared one drive, i tried changing the timer to 5 minutes value but this makes no difference. I seen on a forum that a person had a similar issue but used VB and wrote coding.
I have lots of experience using excel but none using VB i don't know where to start.
what i need help with is a simple code creating to get my dash board pivot tables to refresh at what ever time in minutes then it will talk to my other spreadsheet.
i will also need to know where to input this code.
many thanks in advance for your help!!!!
Paul
I have lots of experience using excel but none using VB i don't know where to start.
what i need help with is a simple code creating to get my dash board pivot tables to refresh at what ever time in minutes then it will talk to my other spreadsheet.
i will also need to know where to input this code.
many thanks in advance for your help!!!!
Paul
