First, AWESOME spreadsheet!
Quote:
Originally Posted by Ed Law
Can you give me one example of which one does not work? ........What version of Excel are you using and what kind of computers are you using?
|
I am using Windows 7 Home Premium and Excel 2013.
I think the tabs people are having problems with are the combined data pages, all of the competition tabs are updated (minus the alliance pick/tournament results "Column O" of course). The "WM data", "WM results", "OPR data", "OPR results", "Adjusted OPR results", and "Worldrank" tabs do not seem to have been updated with the week 4 results. Using CTRL+SHIFT+P on these pages results in "Microsoft Visual Basic Run-time error '1004': Application-defined or object-defined error". Going to debug, the following line in Module 2 (Code) is highlighted: Selection.QueryTable.Refresh BackgroundQuery:=False
Also, column B, the "Location" data is blank for all but Team 1 in each of those tabs.
Truthfully I don't know if you wanted us to use CTRL+SHIFT+P to update those tabs, but it looks like the last time they were updated was week 3.
I think the easiest thing to do on each tab would be to put a small "radio button" or two at the top of the page that would run the expected macro or macros for each tab. Also, if you want the macro to not show the screen updating while it is running, which should make it faster as well, set "Application.ScreenUpdating = False" at the beginning and "= True" just before the end.