External data source excel mac

Anon Gordon Anon Gordon 2 4 Click on Data and then Connections.

Your Answer

I don't see Edit Links at all. I see a window with a top and bottom half to the window. In the bottom half, it has "Locations where connections are used". In my case, these are all just leftover references from stuff copy and pasted, for data which isn't in the spreadsheet any longer some not for a long time. Do you see anything in here? Note that the "Connections" button in the "Data" ribbon is part of a group of buttons also called "Connections".

That's what I was referring to above. And when I click the "Connections" dialog as you describe, it opens a "Workbook Connections" dialog which is empty. Links to external data can exist in formulas named ranges macros called by buttons and shapes conditional formatting Bill Manville MS MVP has created a little tool to find them all. That's a cool tool, but it found no links, and no links that reference ".

Nothing obvious in the conditional formatting either. Great Tool! Note, it looks like you need to close every instance of Excel before Bill's tool will show up after you install it. Took me a minute to realize that.

• Office 2011 for Mac All-in-One For Dummies?
• microsoft office 2010 for mac with crack!
• Use an external data source to create a PivotTable?

Here's the comment I had intended to leave on their post: Anyway, my thanks to whoever pointed this out. This is old, but I just ran into it.

Excel (Mac) Pivot table get external data - How?

A Thanks for pointing this out, and B it's not necessarily External data, it's actually the Pivot Cache that it's wanting to clear, so the message is legitimate, but, in true Microsoft fashion, it's not really clear. If you click Yes to the message, your workbook size on disk will be smaller because the cache s are thrown out, but it will take longer to open the WB because Excel will rebuild each and every one as it opens, then refresh all the pivots.

Passing Through Passing Through 21 1. Not sure why you were voted down, but this is the only way I have found to solve the problem if it is a spurious message caused by a pivot table which it usually is in my case. I would have written my contribution as a comment, if my reputation allowed it.

• Alert: This PivotTable connects to an external data source - Microsoft Community.
• Use an external data source for a PivotTable in Excel for Mac - Excel for Mac?
• kery james feat mac tyer patrimoine du ghetto.
• how to view dcm files on mac.
• einrichten mac os x server.

Jodi Jodi 11 1. Sign up or log in Sign up using Google.

MODERATORS

Sign up using Facebook. Sign up using Email and Password. Post as a guest Name. Email Required, but never shown. Post Your Answer Discard By clicking "Post Your Answer", you acknowledge that you have read our updated terms of service , privacy policy and cookie policy , and that your continued use of the website is subject to these policies.

Related 0. Hot Network Questions. Once the driver for your source is installed, you can follow these steps to use the external data in a PivotTable:. Create a PivotTable to analyze worksheet data. Expand your Office skills. Get new features first. Was this information helpful? Yes No.

Creating a sales report in Excel

Any other feedback? How can we improve it? Send No thanks.

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents. Contact Support.