Excel Pivot Error Data Source Reference Is Not Valid
Contents |
360 games PC games
Pivot Table Error Field Name Is Not Valid
Windows games Windows phone games Entertainment All Entertainment destination reference is not valid pivot table Movies & TV Music Business & Education Business Students & educators
Data Source Reference Is Not Valid Power Map
Developers Sale Sale Find a store Gift cards Products Software & services Windows Office Free downloads & security Internet reference is not valid excel 2010 Explorer Microsoft Edge Skype OneNote OneDrive Microsoft Health MSN Bing Microsoft Groove Microsoft Movies & TV Devices & Xbox All Microsoft devices Microsoft Surface All Windows PCs & tablets PC accessories Xbox & games Microsoft Lumia All reference is not valid excel pivot table refresh Windows phones Microsoft HoloLens For business Cloud Platform Microsoft Azure Microsoft Dynamics Windows for business Office for business Skype for business Surface for business Enterprise solutions Small business solutions Find a solutions provider Volume Licensing For developers & IT pros Develop Windows apps Microsoft Azure MSDN TechNet Visual Studio For students & educators Office for students OneNote in classroom Shop PCs & tablets perfect for students Microsoft in Education Support Sign in Cart Cart Javascript is disabled Please enable javascript and refresh the page Cookies are disabled Please enable cookies and refresh the page CV: {{ getCv() }} English (United States) Terms of use Privacy & cookies Trademarks © 2016 Microsoft
all our training and know-how, we run into a problem in Excel. Today, I'll address possible reasons that your once functional and useful pivot table is now
Invalid Excel Characters
lame, defunct, and just all-around acting like a real jerk. Specifically, you are excel reference is not valid stuck getting an error message that the pivot table data source is not valid. Or, alternatively, the pivot table reference
The Reference Is Not Valid. References For Titles Values Or Sizes
is not valid. Checklist #1 (Re-)save the file to your desktop One extremely common reason for this error is that you are working on a file from the web or a https://support.microsoft.com/en-us/kb/2862807 server - saving the file to desktop is often all that is needed to get the pivot table working again. #2 Check for blank field names and other field name errors Are there fields in the data that are not named? Are there any hidden columns in the data that might have blank named fields? Are the field names too long (over 255 http://www.excelgirl.com/2011/08/pivot-table-data-source-not-valid/ characters in Excel 2003)? #3 Check that the named range underlying the pivot table is not broken Use the wizard or the ribbon to identify the underlying data. Ensure that the named range is valid and not showing a #REF error. Did this information help you? Like me on Facebook! www.facebook.com/excelgirl Load up on more advanced Excel skills by checking out Three rules for working with calculated fields in pivot tables. Learn more about me and how I became an Excel expert. If these tips don't work and you are still experiencing problems, please contact me so that I may identify the problem and add it to this post for the benefit of others. Submit your problem here, or add a comment below. Author kirstenPosted on August 25, 2011July 10, 2014Categories AdvancedTags errors, pivot table 1 thought on “Pivot table data source not valid” Pingback: Pivot Table Error Comments are closed. Post navigation Previous Previous post: Shortcut to select entire rows or columnsNext Next post: How-to insert a calculated field in a pivot table Excel Consultation Excel Training About Contact Excel Girl Proudly powered by WordPress
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn more about Stack Overflow the company Business Learn more about hiring http://superuser.com/questions/330718/excel-data-source-reference-is-not-valid developers or posting ads with us Super User Questions Tags Users Badges Unanswered Ask Question _ https://groups.google.com/d/topic/microsoft.public.excel/EIILrVazU_o Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute: Sign up Here's how it works: Anybody can ask a question Anybody can answer The best answers are voted up and rise to the top Excel data source reference is not valid up vote 1 down vote favorite I am trying to create a is not pivot from a range but keep getting the error Data source reference is not valid I have Googled this and tried all of the following. Select from Table instead from range. Open the Excel spreadsheet click on the view tab and select new window. Save the spreadsheet with a different name for the new window. Click on HOME> PREPARE> INSPECT DOCUMENT> Removed all unneccesary references and xml forms. I have labels on all the columns and all the cells are is not valid populated. I am using Office 2010 on Win7 and the file is in .xlsx format microsoft-excel-2010 pivot-table share|improve this question asked Sep 1 '11 at 12:16 Pieter van Niekerk 3683720 add a comment| 2 Answers 2 active oldest votes up vote 4 down vote accepted I found the reason the pivot tables didn't work was because of the file name. The reports are generated by a report automation system and the name contains square brackets [] that Excel doesn't like. I removed the square brackets totally by chance and found the pivots are working. I also tried to save the file in the Save As option with square brackets but like I said, Excel moans about it and doesn't allow you. share|improve this answer answered Sep 5 '11 at 8:29 Pieter van Niekerk 3683720 add a comment| up vote 3 down vote I had this same error but didn't have brackets [] in my file name. I found that the Excel file from my web-based reporting tool was not actually in XLSX format. When I did a "Save As" in Excel the file type was "Web page". I changed that to "Excel workbook (*.xlsx)" and saved with the same name and the Pivot Table worked. share|improve this answer answered Dec 20 '12 at 22:46 Rich Ellis 514 add a comment| Your Answer draft saved draft discarded Sign up or log in Sign up using Google Sign up using Facebook
från GoogleLogga inDolda fältSök efter grupper eller meddelanden