Tag Archive: Excel

Nov 21

Resolved: Where and How to use Name Management function in Excel 2011 for Mac

Resolved: Where and How to use Name Management function in Excel 2011 for Mac So this is one of those things I keep referring back to. One of the key things I do when I work in Excel is control the values that can be entered in certain fields. I am clearly not good at …

Continue reading »

Mar 21

How to: Resolve issue “This workbook cannot be opened because it is not stored in a trusted location. To create a trusted location, contact your system administrator.” on SharePoint 2013

How to: Resolve issue “This workbook cannot be opened because it is not stored in a trusted location. To create a trusted location, contact your system administrator.” on SharePoint 2013 Right after installing SharePoint 2013 you might run into the issue that when your users try to open an Excel file you run into the error …

Continue reading »

Aug 21

How to: Obtain stock quotes from Yahoo finance (you can query them via Excel too)

How to obtain stock quotes in Excel I was working on creating a spreadsheet to calculate profits and losses on options positions but didn’t know how to populate excel with stock quotes. Back in the day there used to be an interface to get stock quotes with the MSN Money site but it is not …

Continue reading »