FAQ’s

Here are our most common Frequently asked questons. Please review them and if you still have a question, email me at excelbyjoe@gmail.com

What’s the different between the free and paid versions?

The free version only let’s you run 4 lineups and you can only run lineups 2 times in a day.  However all the other features remain the same.  The paid version let’s you run up to 150 lineups as often as you like.

Do I have to Enable macros to get this software to work?

Yes. When you open the software, it may ask you to enable macros. Click yes or click Enable. Otherwise the buttons will not work.

I have a Mac, will this work on a Mac?

Sorry but no it will not right now. It only works in Windows.

I get a 1004 Error message when I press to Refresh the stats. Why?

Refresh pulls data from certain websites and it is possible you may be at work where there is a firewall preventing Excel from accessing some sites.

When it looks for odds, it sometimes visits gambling sites which a occassionally blocked.  If there is an option of yes or no on the Main tab to refresh odds, just put it to No and try to refresh again.

I press refresh but I don’t get any data. Why?

If you get an error message saying your login is incorrect, then you need to enter that in or email me.

If nothing happens, then you need to first be sure you are working on a Windows machine and have Excel 2007 or newer.

Then check your Macro settings to be sure you don’t have security set to High.  Go to File then Options then Trust Center then Macro Settings.  Make sure it isn;t “Disable all macros without notification”

If none of those work, its possible there’s something wrong in the back end, so email me: excelbyjoe@gmail.com

I entered my password but it says it isn’t active?

The first time you enter in your password, you need to press Refresh Logins. That initializes it. Then as long as you are an active subscriber and your password is in there, then you don’t need to press Refresh Logins anymore.

If that still doesn’t work, then email me to check the database. excelbyjoe@gmail.com

How do I cancel?

You can cancel at any time.  Just log into your paypal account and there should be a link in your activity that shows you signed up with us.  Click on it and then you’ll see something that says to Cancel Subscription.  Click that and it will cancel it.

How do I Lock in or Exclude players from lineups?

To lock in or include players in all your lineups, you put an x in the multilineups tab.

To exclude players from your lineups, just change their projection to 0 so they will never get picked.

How do I use the NBA spreadsheets?

You can watch these videos to show you:

 

How do I use the PGA Golf Spreadsheet tool?

How do I use the NFL Football Spreadsheet tool?

How do I use the MMA Spreadsheet tool?

How do I use the Nascar Spreadsheet tool?

When do the salaries get updated for the day/week?

I manually update all the salaries and other stats in our backend database.

For the daily sports like baseball and basketball, the salaries get updated late the night before games or the morning of the games.

For the weekly sports, I try to update when the salaries come out as well as I can. For football I update it on Tuesday nights.

My spreadsheet doesn’t work. Why?

This is a very vague question and can’t be answered without more information. Please read the other FAQ’s to see possible errors. Read through them and some tips below. Then you can email me excelbyjoe@gmail.com if you still can’t figure it out. But please tell me exactly what is going on, like what buttons you are pressing and what happens if anything. also any error messages.

1. Make sure you are in Windows Excel 2007 or newer
2. Restart Excel or even your computer if it isn’t working.
3. Make sure there’s no other Excel programs running or it could cause it to slow.
4. Make sure you have the correct login

Do I need Solver installed?

No you don’t.  I re programmed the lineup optimizer to not have to use Solver.  While Solver was good, it was extremely slow.  So now I have Excel doing the same thing, but just quicker.