Data Source Reference Is Not Valid Error
Contents |
360 games PC games pivot table data source reference not valid error Windows games Windows phone games Entertainment All Entertainment
Excel Error Data Source Reference Is Not Valid
Movies & TV Music Business & Education Business Students & educators
Data Source Reference Is Not Valid Pivot Table 2007
Developers Sale Sale Find a store Gift cards Products Software & services Windows Office Free downloads & security Internet
Data Source Reference Is Not Valid Power Map
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 data source reference is not valid excel 2010 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
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and data source reference is not valid pivot table excel 2013 policies of this site About Us Learn more about Stack Overflow the data source reference is not valid when creating a pivot table company Business Learn more about hiring developers or posting ads with us Super User Questions Tags Users Badges Unanswered data source reference is not valid sparklines Ask Question _ 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 https://support.microsoft.com/en-us/kb/2862807 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 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. http://superuser.com/questions/330718/excel-data-source-reference-is-not-valid 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 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:2
Forums Excel Questions Pivot Table data source reference is not valid Results 1 to 3 of 3 Pivot Table data source reference is not validThis is a discussion on Pivot http://www.mrexcel.com/forum/excel-questions/624994-pivot-table-data-source-reference-not-valid.html Table data source reference is not valid within the Excel Questions forums, part https://groups.google.com/d/topic/microsoft.public.excel/EIILrVazU_o of the Question Forums category; Hi All, I have been using excel 2010 for about a year now and in the past I was able ... 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 data source Switch to Hybrid Mode Switch to Threaded Mode Mar 29th, 2012,10:45 AM #1 vbooth New Member Join Date Jul 2010 Posts 8 Pivot Table data source reference is not valid Hi All, I have been using excel 2010 for about a year now and in the past I was able to create a pivot table with out saving the workbook first. Now in the last couple of data source reference days I can no longer insert a pivot table with out getting the error message "data source reference is not valid." Does anyone have a fix for this, and /or know the root cause? Thank you in advance for your time. Share Share this post on Digg Del.icio.us Technorati Twitter Reply With Quote Mar 30th, 2012,03:48 AM #2 Robert Mika MrExcel MVP Join Date Jun 2009 Location (current) UK, (origin) Poland Posts 7,256 Re: Pivot Table data source reference is not valid I'm gusesing taht your sheet maybe from website/internet. Does this help? http://answers.microsoft.com/en-us/o...d-a2d71f66b676 Share Share this post on Digg Del.icio.us Technorati Twitter - Read the Posting Guidelines, Forum Rules & FAQs - Want to post a small screen shot? Try one of these Excel jeanie, MrExcel HTML Maker or Borders-Copy-Paste - If posting vba code, please use Code Tags . Reply With Quote Mar 30th, 2012,12:33 PM #3 vbooth New Member Join Date Jul 2010 Posts 8 Re: Pivot Table data source reference is not valid Thank you Robert, that does help and gets me to thinking about the situation in the correct frame of mind. It is not an excel issue, but one that i
from GoogleSign inHidden fieldsSearch for groups or messages