Jump to content



Photo

Update cheat sheet error


  • Please log in to reply
1 reply to this topic

#1 TAM2020

TAM2020

    FF Geek

  • Members
  • 194 posts

Posted 28 August 2018 - 08:52 PM

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.

#2 Mike MacGregor

Mike MacGregor

    FF Geek

  • Admin
  • 6,613 posts

Posted 28 August 2018 - 10:35 PM

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.