Home > Cannot Open > Cannot Open Pivottable Source File Sharepoint

Cannot Open Pivottable Source File Sharepoint

Contents

excel vba excel-vba runtime-error pivot-table share|improve this question edited Oct 28 '15 at 20:47 asked Oct 27 '15 at 18:26 Julia 64 1 I'm not sure about this but you Share Share this post on Digg Del.icio.us Technorati Twitter Reply With Quote Aug 17th, 2011,08:24 PM #9 Jerry Sullivan MrExcel MVPModerator Join Date Mar 2010 Location San Diego, California Posts 8,115 At delivery time, client criticises the lack of some features that weren't written on my quote. In excel, click on the PivotTable->ANALYZE->Change Data Source to check it. navigate here

It is then looking for that file on *your* (Katy's) machine. Share Share this post on Digg Del.icio.us Technorati Twitter Reply With Quote Aug 17th, 2011,06:11 PM #7 Jerry Sullivan MrExcel MVPModerator Join Date Mar 2010 Location San Diego, California Posts 8,115 Excel) and then post your question. Do we have "cancellation law" for products of varieties The cost of switching to electric cars? https://social.technet.microsoft.com/Forums/office/en-US/91d96803-1b42-4abb-b6ba-30112396c1c8/error-cannot-open-pivottable-source-file-but-i-am-working-with-only-one-standalone-computer?forum=excel

Cannot Open Pivottable Source File Sharepoint

Note: this code is working perfectly on my pc but only gives the error if I email it and it's opened and run from the email. Mascaro Sep 23 '14 at 15:16 It's an Excel range (on a worksheet that's within the same workbook as the pivottables/charts. The source file was pointing to the shared portal / web link.Solution for Excel 93 - 20071) Highlight (just select) the Pivot table2) Go to Options tab - Under the "Change IN operator must be used with an iterable expression Draw a hollow square of # with given width more hot questions question feed lang-vb about us tour help blog chat data

I have always found Catalin to be creative in solving problems, exceptionally good at delivery and very flexible with timescales.Highly Recommended. It's difficult to tell without seeing the file but as it says the first thing to check is where it's drawing the data from. Amjad SahiAspose - File Format APIsGot a Complaint? Cannot Open Pivottable Source File Refresh All Thanks JoeJoseph DiSabato Thursday, April 03, 2014 1:40 PM Reply | Quote 0 Sign in to vote Hi Disa012, You can click each pivot table in turn and refresh just that

Enter your email address: .NET Blogroll Better Git with PowerShell Brij Hushan Leon Bambrick Mohamed Meligy Rob Conery Scott Guthrie BI Blogroll Andrew Brust Boyan Penev Chris Webb Richard Back Rob Required fields are marked *Visual TextName * Email * Website Sign me up for the newsletter! Katy has attended: Excel Advanced course Powerpoint Intermediate Advanced course "Cannot find pivot table source" errorGood morning I wanted to say thank you so much for all your help so far! Share Share this post on Digg Del.icio.us Technorati Twitter Reply With Quote Aug 17th, 2011,05:09 PM #3 Jerry Sullivan MrExcel MVPModerator Join Date Mar 2010 Location San Diego, California Posts 8,115

File it! How To Find Cannot Open Pivottable Source File xxxxHannah MorrisonSapphire GymnasticsAbsolutely FantasticI set Catalin a challenge - it related to automating a quote through to Invoice and went so far as creating a template to upload into our accounting Frequently Asked Questions What does 'Resolved' mean? Then I remembered that Icopied (2) pivots tables out of this tab into another new tab...(probably with cut and paste?) Went there and found the 2 tables causing the problem!!

  1. You should put this code in the Workbook_Open event.
  2. However, when he goes to open the spreadsheet and then refresh the pivot table/chart, the following error message comes up: Cannot find pivot table source Is there anything that can be
  3. Forum Board FAQ Forum Rules Guidelines for Forum Use FAQ Forum Actions Mark Forums Read Quick Links Today's Posts Search New Posts Zero Reply Posts Subscribed Threads MrExcel Consulting Advanced Search
  4. Is there any way round this?
  5. All contents Copyright 1998-2016 by MrExcel Consulting.
  6. Do you or anyone else have any other suggestions that might help workaround this error I am still having?
  7. This is causing error when I am opening this file through Open/Save File dialog box in Internet Explorer.
  8. RE: "Cannot find pivot table source" errorHi Katy Thanks for getting in touch.

Cannot Open Pivottable Source File Excel 2016

Is there anyway you can send me a screen shot of where this should be? Source Thank you Katy Wed 29 May 2013, 11:06 Reply Trainer Gary said... Cannot Open Pivottable Source File Sharepoint Code: Activeworkbook.RefreshAll Share Share this post on Digg Del.icio.us Technorati Twitter Using Excel 2016 Reply With Quote Aug 17th, 2011,07:18 PM #8 ikauai New Member Join Date Jul 2011 Posts 10 Cannot Open Pivottable Source File Error Excel 2013 Now what?

Add Excel macros to the report to dynamically rename the PivotTable to exclude the bracket and then refresh the PivotTable. http://optimisersonpc.com/cannot-open/word-cannot-open-the-file-because-the-file-format-does-not-match-the-file-extension.html Then replace the Source Data location with this networked version. As always my spec was far from thorough but Catalin worked through it and created then entire workflow with 4 days.It worked first time and works on both a PC and When user directly saves the file then Pivot table is generated properly. Excel Pivot Table Cannot Find Source File

Showing recent items. This is so frustrating; any help greatly appreciated Edited by disa012 Sunday, March 30, 2014 4:32 PM Sunday, March 30, 2014 4:16 PM Reply | Quote Answers 1 Sign in to Privacy Policy | Terms of use | Contact Us Register Help Remember Me? http://optimisersonpc.com/cannot-open/cannot-open-source-file-iostream-visual-studio-2015.html Notify me of new posts by email.

Share it with others Like this thread? Cannot Open Pivottable Source File Temporary Internet Files We have made these solutions available online because our customers have found the information helpful. Note: This is not an issue with the OfficeWriter product.

My cat sat down on my laptop, now the right side of my keyboard types the wrong characters Reverse a hexadecimal number in bash Is it ethical for a journal to

Keep in touch! If the option is greyed, you can only activate it if you use the Document Inspector.Users should do this on a copy of their file, it’s not bullet proof, if they Found it during the investigation : "The problem with the Content-Disposition: inline is that it doesn't pick the file name from filename attribute we use in AddHeader function rather, it always Cannot Open Pivottable Source File Vba Going forward, it appears I am still stuck with the error caused by trying to dynamically change the datasource for the pivottable on the first onopen event for the workbook.

RE: "Cannot find pivot table source" errorHi Gary Yes that helps, my colleague has found the link. Kind regards Gary Fenn Microsoft Office Specialist Trainer Tel: 0845 5194 797 Best STL - http://www.microsofttraining.net 98%+ recommend us London's leader with UK wide delivery in Microsoft Office training and management Cheers, CatalinReply Prasad says: July 25, 2016 at 4:36 pmHi Catalin, thanks a ton for the solution… similar problem was resolved at our end with detailed and clear step wise instructions….Reply http://optimisersonpc.com/cannot-open/cannot-open-excel-files-from-sharepoint.html Your Answer draft saved draft discarded Sign up or log in Sign up using Google Sign up using Facebook Sign up using Email and Password Post as a guest Name

Dim rCount As Long Dim Rng As Range rCount = Worksheets("example raw data").Range("A:A").Cells.SpecialCells(xlCellTypeConstants).Count Set Rng = Worksheets("example raw data").Range("A1:AH" & rCount) ActiveSheet.PivotTables("PivotTable1").ChangePivotCache ActiveWorkbook. _ PivotCaches.Create(SourceType:=xlDatabase, SourceData:=Rng, Version:=xlPivotTableVersion12) So, I am still Glad you found the problem though :-) Regards, Jan Karel Pieterse|Excel MVP|http://www.jkp-ads.com Marked as answer by disa012 Wednesday, September 14, 2016 6:41 PM Monday, April 07, 2014 6:48 AM Reply | The sheet is named "example raw data". share|improve this answer answered Sep 23 '14 at 15:59 Mr.

United Kingdom Terms & Conditions Privacy & Cookie Policy Request A Callback Request a callback We'll call during UK business hours Name: Number: SoftArtisans Search Primary Menu Skip to content About If you are using excel 2013,when you rename or move your workbook, your PivotTable data source maychanged . You may try to change the source of the pivot table if it fits your need. As you have found this can lead to unexpected problems. 2.

Last edited by ikauai; Aug 17th, 2011 at 06:08 PM. In the bottom-right of the table you should have a big grand total of all the data. How Getting Together Is Now Even Easier With ExcelSimple Ways To Customise ExcelFeatures of Microsoft Excel that assist in Analysis of Financial Data Please browse our web site to find out I understand that it's strange that it works on your computer but not others, but I'm trying to show you a better way to approach this instead of trying to find

stdarg and printf() in C When booking a cruise, how can I find a list of all the fees in advance? Is it an Excel range or a RecordSet? –Mr. When data is added / modified on the source sheet, this will be reflected on the PivotTable. Explore below or use the search box above.

Mascaro 2,2871414 add a comment| Your Answer draft saved draft discarded Sign up or log in Sign up using Google Sign up using Facebook Sign up using Email and Password I haven't used .PivotTableWizard in macros, but it appears to be intended to create PT's not update them. Kind regards Gary Fenn Microsoft Office Specialist Trainer Tel: 0845 5194 797 Best STL - http://www.microsofttraining.net 98%+ recommend us London's leader with UK wide delivery in Microsoft Office training and management

Back to Top