excel error cannot open pivottable source file Clearlake Park California

Address Lakeport, CA 95453
Phone (707) 262-0340
Website Link http://beyondcomputers.biz
Hours

excel error cannot open pivottable source file Clearlake Park, California

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. I didn't create the file so wasn't aware there were hidden sheets. It is then looking for that file on *your* (Katy's) machine. Data-Edit Links - Break Links..

I thought perhaps the links didn't update when the file was moved from a temporary location to being saved on a hard drive, but I triple checked all of the PivotTable Can a Legendary monster ignore a diviner's Portent and choose to pass the save anyway? Excel - Tips and Solutions for Excel Privacy Statement Terms of Service Top All times are GMT -4. When must I use #!/bin/bash and when #!/bin/sh?

I have many Pivot Tables, and I can't find that one with the error, while refreshing separately – there are no errors, no hidden sheets. If you run the code it will break if any error occurs. United Kingdom Terms & Conditions Privacy & Cookie Policy Request A Callback Request a callback We'll call during UK business hours Name: Number: Register Help Forgotten Your Password? Free Excel Learning JourneyCh. 1: General KnowledgeCh. 2: Excel FunctionsCh. 3: Excel Defined Tables Recent Posts LEN function: Basic and Advanced Examples SUBSTITUTE function: Basic and Advanced Examples Working with Excel

I notice that it points to her local path in the Temp folder '\Documents and Settings\csanwal\Local Settings\Temporary Internet Files\Content.IE5\531HK9FR\[PSS Dashboard NOV FY12 WIP[1].xlsx]Data SSB CINCH'!$A$1:$AH$261 Currently I would manually go through Share Share this post on Digg Del.icio.us Technorati Twitter Reply With Quote Dec 18th, 2011,03:29 PM #5 Doug H New Member Join Date Dec 2011 Posts 9 Re: Cannot open PivotTable Share Share this post on Digg Del.icio.us Technorati Twitter Reply With Quote Dec 18th, 2011,05:53 PM #8 Jerry Sullivan MrExcel MVPModerator Join Date Mar 2010 Location San Diego, California Posts 8,111 If this comes from an external file that your colleague cannot access or other database, you should check they can get to that data first.

Remember Me? Excel) and then post your question. 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 microsoft-excel microsoft-excel-2010 pivot-table share|improve this question edited Jan 19 '14 at 11:17 slhck 125k38315362 asked Jan 19 '14 at 9:52 Spon4ik 113 for now, deleted one by one sheets

If you are using excel 2013,when you rename or move your workbook, your PivotTable data source maychanged . Gosh!!! Public Sub RefreshAllPivotTables() Dim Sheet As Worksheet, Pivot As PivotTable For Each Sheet In ThisWorkbook.Worksheets For Each Pivot In Sheet.PivotTables Debug.Print Sheet.name & "-->" & Pivot.name Pivot.RefreshTable Pivot.Update Next Next End Quick Fix Friday, September 30, 2011 Fix for Excel Error : Cannot Open Pivot Table source File Fix for Excel Error : Cannot Open Pivot Table source fileWhen an excel file

Project going on longer than expected - how to bring it up to client? need book id, written before 1996, it's about a teleport company that sends students learning to become colonists to another world With the passing of Thai King Bhumibol, are there any Then she would go through and manually update the source data. 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

Book with confidence up to 12 months ahead. Unusual keyboard in a picture Is there any job that can't be automated? Is there anyway you can send me a screen shot of where this should be? Email Address Recent CommentsCatalin Bombea on Autoexpand Excel Tables on Protected SheetsJulian De Silva on Autoexpand Excel Tables on Protected SheetsCatalin Bombea on Autoexpand Excel Tables on Protected SheetsLouis C on

Microsoft Customer Support Microsoft Community Forums Excel FirstExcel SolutionsLearn ExcelGeneral KnowledgeCell ModesExcel RangesDefined NamesExcel FunctionsWorking with FormulasText FunctionsDefined TablesExcel Table ComponentsSelecting Table ComponentsAboutServicesContactTipsCan't Open Pivot Table Source filePosted by: Catalin Bombea didn't try, but I think wouldn't help, because there was a problem with one of pivot, found it by deleting sheets one by one. –Spon4ik Apr 6 '14 at 5:54 add Share Share this post on Digg Del.icio.us Technorati Twitter Reply With Quote Dec 18th, 2011,03:44 PM #6 Jerry Sullivan MrExcel MVPModerator Join Date Mar 2010 Location San Diego, California Posts 8,111 If you are satisfied with the solution(s) provided, please mark your thread as Solved.

The difficulty is that I have so many tabs and multiple pivot tables in each tab that is very difficult to determine WHAT specific table is causing the problem. Originally Posted by Doug H We need to upload the file for version control on Documentum so we don't inadvertently clobber each others updates. Thanks Marked as answer by disa012 Wednesday, September 14, 2016 6:41 PM Wednesday, September 14, 2016 6:35 PM Reply | Quote All replies 0 Sign in to vote Hi Disa012, You 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!!

Now what? Register To Reply 03-20-2014,07:32 AM #5 :) Sixthsense :) View Profile View Forum Posts Forum Guru Join Date 12-31-2011 Location India MS-Off Ver 2003 To 2010 Posts 12,039 Re: PivotTable source http://www.excelaris.co.uk Register To Reply 03-20-2014,01:58 AM #3 :) Sixthsense :) View Profile View Forum Posts Forum Guru Join Date 12-31-2011 Location India MS-Off Ver 2003 To 2010 Posts 12,039 Re: PivotTable I have emailed a spreadsheet (inc pivot tables and charts) to a colleague.

What sense of "hack" is involved in five hacks for using coffee filters? Why does the material for space elevators have to be really strong? The source referenced is not listed when I click "Edit Links"If I do a formula search for the file name in the ENTIRE workbook, nothing is foundAll files are on only What's the most recent specific historical element that is common between Star Trek and the real world?

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 We have the ability to be flexible through our experience and commitment to quality. What is the best way to upgrade gear in Diablo 3? 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

And what about "double-click"? Forum Today's Posts FAQ Calendar Community Groups Forum Actions Mark Forums Read Quick Links What's New? About Me Renuka I am a fun loving person and have a great passion for cooking. Though there is a checkin/checkout feature in Documentum, we haven't really been using it since it is just the two of us working on this file.

What is a type system? 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 Please post in the Improve the forum thread. Template4 points · 2 comments I'd like to translate an excel VBA into a document that describes the entire process in a readable way.8 points · 2 comments Is it possible to apply a color

Every time I hit refresh all I get an error message that says 'Cannot open PivotTable source file" with a link to a temp file (the original workbook was downloaded off All the data sources for all the pivots are local tables. Cannot open PivotTable source file 'C:\Users\Joe\...\[file-name.xlsm]