Refreshing Data in Excel for Mac

Boy, Excel for Mac can be a real pain in the butt sometimes. In particular, refreshing data within a Mac Excel spreadsheet is near impossible.

This is an issue that many of our users run into. Thankfully, we've got two simple solutions for you, and this blog walks you through each one step by step.

If you want a quick, easy fix - use Method #1. It will, however, require you to follow the process each and every time you want to refresh your data.

If you have 5 minutes, scroll down to Method #2. This method will help you create a button, and it's as simple as that. To refresh your spreadsheet data, at any time - just click the button.

Remember, our team is always available via chat if you run into problems. We are here to help.

Method #1

Run the IntrinioRefresh Macro

  1. At the top of the screen, click on "Excel" then "Preferences"

Screen Shot 2017-12-06 at 1.15.53 PM

2. Double click on "Ribbon & Toolbar"

Screen Shot 2017-12-06 at 1.17.05 PM

3. On the right hand side, check the box next to "Developer"

Screen Shot 2017-12-06 at 3.16.39 PM

4. Click "Save" in the bottom right hand corner

Screen Shot 2017-12-06 at 2.54.10 PM

5. You should now see a tab at the top of the Excel spreadsheet called "Developer". Click on it.

Screen Shot 2017-12-06 at 3.18.21 PM

6. On the left hand side, you should see a button called "Macros" with a bright green arrow. Click on it.

Screen Shot 2017-12-06 at 3.20.01 PM

7. A prompt will pop up. In the top where it says "Macro Name", type "IntrinioRefresh"

Screen Shot 2017-12-06 at 3.21.14 PM

8. In the bottom right hand corner, click run.

Screen Shot 2017-12-06 at 3.22.08 PM

9. Your data will update in the spreadsheet!

Method #2

Create a Macro Button in Your Toolbar

  1. At the top of the screen, click on "Excel" then "Preferences"

Screen Shot 2017-12-06 at 1.15.53 PM

2. Double click on "Ribbon & Toolbar"

Screen Shot 2017-12-06 at 1.17.05 PM

3. On the right hand side, at the bottom, click the + button

Screen Shot 2017-12-06 at 1.26.29 PM

4. Click "New Tab"

Screen Shot 2017-12-06 at 1.30.56 PM

5. Click on the "New Tab (Custom)" that shows up

Screen Shot 2017-12-06 at 1.32.26 PM

6. Click the settings symbol at the bottom, and click "Rename..."

Screen Shot 2017-12-06 at 1.33.09 PM

7. Name this tab "Intrinio" and click "Save"

Screen Shot 2017-12-06 at 1.35.06 PM

8. Underneath your new tab, click "New Group (Custom)"

Screen Shot 2017-12-06 at 1.35.58 PM

9. On the left hand side, click "Choose commands from", and select "Macros"

Screen Shot 2017-12-06 at 1.07.51 PM

10. Scroll down and select "IntrinioRefresh"

Screen Shot 2017-12-06 at 1.08.03 PM

11. Click the right-facing arrow in the middle

Screen Shot 2017-12-06 at 2.49.55 PM

12. You should see "IntrinioRefresh" show up underneath your new custom group on the right.

Screen Shot 2017-12-06 at 12.47.02 PM

13. Click "Save"

Screen Shot 2017-12-06 at 2.54.10 PM

14. Now, at the top of your workbook, you should see a tab called "Intrinio". Click on that.

Screen Shot 2017-12-06 at 2.55.32 PM

15. Underneath it should be a button called "IntrinioRefresh". Now, every time you click that button, the data in your spreadsheet will refresh.

Screen Shot 2017-12-06 at 2.59.36 PM

16. Good job! You're an Excel Guru.

GURU