3ecommunications.net

Home > Is Not > Data Source Reference Is Not Valid Excel Pivot Table

Data Source Reference Is Not Valid Excel Pivot Table

Contents

The causeis due to square brackets being invalid characters in an Excel workbook file name. Toby Erkson, Sep 30, 2004, in forum: Microsoft Excel Discussion Replies: 4 Views: 413 Toby Erkson Oct 4, 2004 Pivot table not sorted... "Data source order" not awailable Guest, Jan 23, I saved it with a new file name (sales1.xlsx rather > > than sales.xlsx) and it worked just fine !! > > > > How odd. > > > > > Stay logged in Welcome to PC Review!

When I save it somewhere with the same filename it just works! When I converted to Excel 2007 I started getting this error message. Select from Table instead from range. Any idea why ? https://support.microsoft.com/en-us/kb/2862807

Data Source Reference Is Not Valid Excel Pivot Table

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? It takes just 2 minutes to sign up (and it's free!). I have labels on all the columns and all the cells are populated. It should all be relative just with sheets.

The Ooh-Aah Cryptic Maze Did Jack die at the end from a shotgun wound? Or, alternatively, the pivot table reference is not valid. I am really getting annoyed as the same data which have imported from CRM system some times work and other times does not work. Reference Is Not Valid Excel 2010 Excel 2013 and 2010, probably earlier versions too - feel free to write in the comments below about your experiences.

Open the Excel spreadsheet click on the view tab and select new window. The advantage o... shiro, Aug 22, 2007, in forum: Microsoft Excel Discussion Replies: 0 Views: 199 shiro Aug 22, 2007 reference is not valid message for pivot tables based on Access query Doug Glancy, pop over to these guys Phil" Source: https://social.technet.microsoft.com/Forums/exchange/en-US/43bf5110-dfad-40e5-a71c-e9736da6fbc2/data-source-path-in-pivot-table-changes-to-absolute-on-its-own?forum=excel&prof=required share|improve this answer answered Aug 4 '15 at 9:18 Gerónimo Tutusaus 92 add a comment| up vote 1 down vote I had this very issue (using Excel 2013).

When you try to refresh the pivot table data, Excel can't find the data because it's referring to the wrong/incorrect table name. Invalid Excel Characters Yes, my password is: Forgot your password? Share Share this post on Digg Del.icio.us Technorati Twitter Reply With Quote « Previous Thread | Next Thread » Tags for this Thread error message, pivot table 2007/2010 View Tag Cloud I saved it with a new file name (sales1.xlsx rather than sales.xlsx) and it worked just fine !!

Pivot Table Error Field Name Is Not Valid

Move directories despite of errors What does the expression 'seven for seven thirty ' mean? http://www.mrexcel.com/forum/excel-questions/624994-pivot-table-data-source-reference-not-valid.html 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 Data Source Reference Is Not Valid Excel Pivot Table Does this help? Destination Reference Is Not Valid Pivot Table The reports are generated by a report automation system and the name contains square brackets [] that Excel doesn't like.

As soon as I use "Save As" all my pivot tables start referring to the old file. Thank you in advance for your time. I guess my next course of action will be to investigate the ie8 security options and the different settings to see if there is any other way around this. Are there any hidden columns in the data that might have blank named fields? Reference Is Not Valid Excel Pivot Table Refresh

How should I respond to absurd observations from customers during software product demos? Hello and welcome to PC Review. {{offlineMessage}} Try Microsoft Edge, a fast and secure browser that's designed for Windows 10 Get started Store Store home Devices Microsoft Surface PCs & tablets Xbox Virtual reality Accessories Windows phone Reply With Quote Mar 30th, 2012,01: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

Conflicting definitions of quasipolynomial time Where can I report criminal intent found on the dark web? Excel Reference Is Not Valid Stuck Share Share this post on Digg Del.icio.us Technorati Twitter Reply With Quote Mar 30th, 2012,04:48 AM #2 Robert Mika MrExcel MVP Join Date Jun 2009 Location (current) UK, (origin) Poland Posts Are you sure you don't have any hidden un-named columns?

Oliver Marshall Guest Hi, I'm trying to create a pivot table in Excel 2007, something I have done a thousand times in 2003.

All contents Copyright 1998-2016 by MrExcel Consulting. All data referred to by the pivot tables are contained within this workbook ("Version 1"). 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 Excel Reference Is Not Valid Cannot Quit It's opening the file from a temporary folder.

Using the Change Data Source allows you to select where your pivot table gets its data from. 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. I'm on "Microsoft Office Professional Plus 2013". –krubo Oct 6 '16 at 23:38 That's strange. (3) definitely works for me. Apparently the pivot tables link to the first reference.

If that doesn't work, you can email me a copy of the workbook and I will see if I can see what the problem is. Likes (0) Quote Replies Please login or register to join the discussion. TechBlog by Michael Gerrard. Click 'Options' button (left side of ribbon in my Excel), switch to Data tab and uncheck "Save source data with file".

Each column contains only one data type (ie either a number, or a currency, or a date etc) and the whole table is set as a table with the name SALES. Refresh pivot table. Click ANALYZE and Change data source button. After doing all of these steps the problem has not returned.

If you're having a computer problem, ask on our forum for advice. Each column contains only one data type (ie either a number, or a currency, or a date etc) and the whole table is set as a table with the name SALES.Whether What are the benefits of an oral exam? But it's easily fixed with the Change Data Source option or by changing the table name.

In Windows Explorer, right-click on the file and select copy.