Hi all,
I created a workbook to keep track of issues with my software which contains all of our tasks. I then created a separate spreadsheet in another workbook to keep track of everybody’s issues to get a feel for how much bandwidth they had. To do this, I created a table in their separate spreadsheets that referenced the tasks workbook. I also created a macro button to keep the files updated. This macro opens up the task workbook, activates the employee’s workbook, refreshes the table on the employees spreadsheet, activates the task workbook, then closes the task workbook.
Every time I use this button it works flawlessly, refreshing all of the employee data with the most up to date information from the task workbook. I uploaded the file to our sharepoint site and tested it there too, works great. However, whenever somebody else tries to use the refresh button, it goes through the whole process of opening the workbooks, refreshing (at least it looks like it), and closing the task workbooks. When the process is over, none of the information has changed.
I don’t have any security on the files, and they all have complete access on sharepoint too. I checked the code and everyone was a perfect copy of my original. Any ideas on what could be happening?
Thank you!
I created a workbook to keep track of issues with my software which contains all of our tasks. I then created a separate spreadsheet in another workbook to keep track of everybody’s issues to get a feel for how much bandwidth they had. To do this, I created a table in their separate spreadsheets that referenced the tasks workbook. I also created a macro button to keep the files updated. This macro opens up the task workbook, activates the employee’s workbook, refreshes the table on the employees spreadsheet, activates the task workbook, then closes the task workbook.
Every time I use this button it works flawlessly, refreshing all of the employee data with the most up to date information from the task workbook. I uploaded the file to our sharepoint site and tested it there too, works great. However, whenever somebody else tries to use the refresh button, it goes through the whole process of opening the workbooks, refreshing (at least it looks like it), and closing the task workbooks. When the process is over, none of the information has changed.
I don’t have any security on the files, and they all have complete access on sharepoint too. I checked the code and everyone was a perfect copy of my original. Any ideas on what could be happening?
Thank you!