TAM2020 0 Posted August 29, 2018 Running excel on a Mac and when I hit update cheat sheet I get an error that is titled Visual Basic for Applications. Then says Run-time error 1004: Method Refresh of object _QueryTable failed And when I hit compile cheatsheets I get a similar run tim error 1004 but it says Application-defined or object -defined error I draft tomorrow night so help please. Share this post Link to post Share on other sites
Mike MacGregor 20 Posted August 29, 2018 Hi TAM. Sorry to hear you are having trouble. I don't usually knee jerk to this but would you mind trying to download a fresh copy and before you even change any settings try to Compile Cheatsheets. This seems familiar to someone else who downloaded and the macros got removed on them. I'm hoping the same issue here and a re-download fixes it. Also if you download again you shouldn't need to update projections, as it will already have the latest update. Share this post Link to post Share on other sites