Home > Cannot Open > Excel Vba Cannot Open Pivottable Source

Excel Vba Cannot Open Pivottable Source


This error is limiting the ability to change Pivot Styles. In response to point #1, the file I am in the process of creating is going to be used as a sort of template for an excel download file from a OP - please reply to the answer with: Solution Verified This will change the flair to SOLVED and award the user a ClippyPoint TO APPLY CODE FORMATTING Use 4 spaces to This will tell you where the underlying data for the PivotTable lives. Source

It keeps giving the following error: http://imgur.com/xNU1R2F (Cannot find PivotTable source file) The thing is, the file is saved in that location under the same exact name. Windows 7 Now for background I often save my file under a new name: suppose my original file is "Checking"I then save it as CheckingXX in the same folderthenrename previous version Many thanks (again!) Katy For upcoming training course dates see: Pricing & availability Wed 29 May 2013, 09:39 Reply Trainer Gary said... he pivot table error message about the missing source file give NO clue what tab its in nor the location of the pivot table.

Cannot Open Pivottable Source File Excel 2010

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 Share Share this post on Digg Del.icio.us Technorati Twitter Using Excel 2016 Reply With Quote Aug 17th, 2011,06:06 PM #6 ikauai New Member Join Date Jul 2011 Posts 10 Re: Cannot permalinkembedsavegive goldaboutblogaboutsource codeadvertisejobshelpsite rulesFAQwikireddiquettetransparencycontact usapps & toolsReddit for iPhoneReddit for Androidmobile websitebuttons<3reddit goldredditgiftsUse of this site constitutes acceptance of our User Agreement and Privacy Policy (updated). © 2016 reddit inc.

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 Joe Joseph DiSabato Marked as answer by disa012 Friday, April 04, 2014 1:15 PM Unmarked as answer by disa012 Sunday, March 20, 2016 5:35 PM Friday, April 04, 2014 1:15 PM Plus high quality training...could this be the best value training company in London!?" - Graham C., Learning & Development Manager, Home Office More Reviews 98.9% Of all customers recommend us, we're Excel Pivot Table Cannot Find Source File Forum Today's Posts FAQ Calendar Community Groups Forum Actions Mark Forums Read Quick Links What's New?

Ozgrid Retains the Rights to ALL Posts and Threads Cannot Open Pivottable Source File Excel 2016 Cancel Register Help Forgotten Your Password? LinkBack LinkBack URL About LinkBacks Bookmark & Share Digg this Thread!Add Thread to del.icio.usBookmark in TechnoratiTweet this thread Thread Tools Show Printable Version Display Linear Mode Switch to Hybrid Mode Register To Reply 02-04-2015,01:04 PM #4 T22 View Profile View Forum Posts Registered User Join Date 01-21-2015 Location Russellville, AR MS-Off Ver 2010 Posts 3 Re: Cannot open PivotTable source file

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. Cannot Open Pivottable Source File Temporary Internet Files Our MS Desktop & Management Skills courses are never cancelled. 98.9% Of all customers recommend us, we're so confident about our results we publish all reviews and stats View Live Stats Wrong way on a bike lane? Privacy statement  © 2016 Microsoft.

Cannot Open Pivottable Source File Excel 2016

Explore below or use the search box above. Register To Reply 01-28-2015,02:48 PM #2 PeteABC123 View Profile View Forum Posts Forum Contributor Join Date 09-21-2012 Location Botswana MS-Off Ver Excel 2013 Deluxe Posts 340 Re: Cannot open PivotTable source Cannot Open Pivottable Source File Excel 2010 I need to update the pivot table with a data source that will be a different size with each download otherwise the refreshall method would work perfectly. Cannot Open Pivottable Source File Sharepoint Share it with others Twitter Linked In Google Reddit StumbleUpon Posting Permissions You may not post new threads You may not post replies You may not post attachments You may not

Regards, Jan Karel Pieterse|Excel MVP|http://www.jkp-ads.com Friday, April 04, 2014 8:53 AM Reply | Quote 0 Sign in to vote Yes, that is a solution, but a poor one given the number http://tcsmacs.net/cannot-open/lcov-cannot-open-source-file.php Here is the FAQ for this forum. + Reply to Thread Results 1 to 7 of 7 Cannot open PivotTable source file Thread Tools Show Printable Version Subscribe to this Thread… asked 1 year ago viewed 567 times Upcoming Events 2016 Community Moderator Election ends Nov 22 Related 3Excel VBA - PivotTable Filter Runtime Error '1004' PivotItems1excel cannot complete this task due Ballpark salary equivalent today of "healthcare benefits" in the US? Cannot Open Pivottable Source File Error Excel 2013

Powered by vBulletin Version 4.1.8 Copyright 2012 vBulletin Solutions, Inc. I have also tried putting it in different locations to no avail. 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 have a peek here 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.

I am not sure if the error is related to the IE browser or what...but I need to make it work from an email or website open as well. How To Find Cannot Open Pivottable Source File cannot find pivot table Contact Us About Resources Sign in Formerly Best Training Excellent Request Callback We will call you back 0207 987 3777 Call for assistance Your Basket Basket is I have emailed a spreadsheet (inc pivot tables and charts) to a colleague.

Why there are no approximation algorithms for SAT and other decision problems?

I saved it and then reopened the file and when I try to Refresh the data I get the same error message. at least that's how is used to reference ranges outside the active workbook. –Munir Oct 27 '15 at 21:30 It looks like you're using R1C1 notation, however that's not 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 Cannot Open Pivottable Source File Refresh All To start viewing messages, select the forum that you want to visit from the selection below.

I have tried replacing the path with the range of the spreadsheet (which isn't ideal if I want to use it on other spreadsheets), but that produced an application-defined or object-defined For example the formula =A1/B1 will return a #DIV/0 if B1 is empty or a zero. This source file is a report in a book that is several years old. Check This Out Is it possible that you post a sample of the file containing the malfunctioning pivot table?

Congratulations and thank you to these contributors Date User CP 2016.11.02 _intelligentLife_ 100 2016.10.31 KarmaIsAFemaleDog 10 2016.10.27 yellising 10 2016.10.23 rnelsonee 700 2016.10.19 datcv 10 2016.10.17 hrlngrv 100 2016.10.12 empire539 50 Nothing is found. current community chat Stack Overflow Meta Stack Overflow your communities Sign up or log in to customize your list. I have ran a search and find on the entire workbook for the wrong source file.

Search or use up and down arrow keys to select an item. If you are using IE 7 or later, you will need to configure the registry on the client to use this option. TrustScore 9.4 | 364 reviews Share this page on: Twitter Facebook LinkedIn Google+ Pinterest Connect with us: Request Callback We will call you back 0207 987 3777 Call for I have always found Catalin to be creative in solving problems, exceptionally good at delivery and very flexible with timescales.Highly Recommended.

Since Excel does not allow pivot table data sources to contain brackets, when the cached file is opened, the pivot tables try to refresh using the temporary file name.