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 FreeNAS - first time setup Introduction NAS means Network Attached Storage. Illustrator - move an object to another layer In Adobe Illustrator CS5, if you accidentally created an object in the wrong layer, it is easy to move it: In the Layers Cheers. , May 20, 2013 #12 Guest I got this error message when I tried to create a pivot table in a file which had the following characters within a
Member Login Remember Me Forgot your password? Does this help? By paulwakefield1 30th Jul 2011 07:52 Some thoughts Try saving the datasource under a new filename in Excel (CRM filenames and temp directories are known to cause problems) Some other thoughts: 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?
Destination Reference Is Not Valid Pivot Table
If you were to try to save a workbook from within Excel using a filename with square brackets in the filename, you will be notified that you are trying to use However, no matter what I do, the wizard just tells me that the data source reference is not valid. Well, despite what the error message suggests, it is probably not your data source that is invalid, it is most likely the filename of your workbook that causes this problem.
When I save it somewhere with the same filename it just works!Had the same problem."Oliver Marshall" wrote:> Weirdest thing.
Whether I type the name of the table, or let the wizard select it, or type a range of cells, or drag using the selector in the wizard, i just says
shiro, Aug 22, 2007, in forum: Microsoft Excel Discussion Replies: 0 Views: 195 shiro Aug 22, 2007 reference is not valid message for pivot tables based on Access query Doug Glancy,
Please try the request again.
If you're having a computer problem, ask on our forum for advice.
Try again with Data>Insert table>give it a different name>then with cursor within the table>Data>Options>Create Pivot Table.
If you get a chance could you please help me to fix this as soon as you can. It will work if it is a saved csv, xls, xlsx, etc. The program that I used to export the original data puts it i n web page format, and uses underscores on both the sheet name and file name. Excel Reference Is Not Valid Stuck Please help!
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. Invalid Excel Characters I saved it with a new file name (sales1.xlsx rather > than sales.xlsx) and it worked just fine !! > > How odd. > > > Ta anyway > Bart, Dan, Feb 7, 2013 #10 Guest On Wednesday, December 19, 2007 9:01:01 PM UTC+8, Bart wrote: > Maybe it has to do when you are opening the excel file from a 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.
Pivot Table Error Field Name Is Not Valid
I was using Windows 7 with Internet Explorer 9, but because Business Objects was being upgraded from version 2x to 3x I had uninstall ie9 and revert back to ie8 because You'll get the same error "Data Source Reference Not Valid". Destination Reference Is Not Valid Pivot Table more stack exchange communities company blog Stack Exchange Inbox Reputation and Badges sign up log in tour help Tour Start here for a quick overview of the site Help Center Detailed Reference Is Not Valid Excel 2010 It is not an excel issue, but one that is more of a Windows 7 and Internet Explorer 8 issue. Your assumption is correct
I have labels on all the columns and all the cells are populated. As soon as I saved the file in another, non-temp location, it worked. I saved it with a new file name (sales1.xlsx rather > than sales.xlsx) and it worked just fine !!> > How odd. > > > Ta anyway> Thanks Bart - I Erlandsen Data Consulting Tips about Excel, VBA programming, services from EDC and other more or less interesting computer stuff… Skip to content VBA Tips About EDC About OPE Om EDC Om Data Source Reference Is Not Valid Power Map
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 server - saving Japanese Mahjong Score Calculator What happens if BB-8 rolls the wrong way? Are you sure you don't have any hidden un-named columns? 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.
Reply Jeremy Collins Aug 9 Check to also see if the workbook is protected. Excel Reference Is Not Valid Cannot Quit Thanks for the tip! , Jul 23, 2012 #6 Guest I had the same issue. I am really getting annoyed as the same data which have imported from CRM system some times work and other times does not work.
share|improve this answer answered Sep 5 '11 at 8:29 Pieter van Niekerk 3733720 add a comment| up vote 3 down vote I had this same error but didn't have brackets 
Finding Residue Does Harley Quinn ever have children? Thanks (0) By Cantona1 01st Aug 2011 12:12 Data source reference is not valid in Pivot TableHi Paul, You are right! I saved it with a new file name (sales1.xlsx rather than sales.xlsx) and it worked just fine !! Reference Is Not Valid Excel Hyperlink Thank you in advance for your time.
Powered by Blogger. It's opening the file from a temporary folder. once saved to an XLS file it worked without any issues. Toby Erkson, Sep 30, 2004, in forum: Microsoft Excel Discussion Replies: 4 Views: 405 Toby Erkson Oct 4, 2004 Pivot table not sorted... "Data source order" not awailable Guest, Jan 23,
That was my solution. , Apr 8, 2014 #20 Advertisements Show Ignored Content Want to reply to this thread or ask your own question? You helped me and I appreciate it! 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 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
You need to save the file locally and then you can create the pivot table. ; ) Top reasons for that error * Blank Column Names * Hidden Columns (that have Now in the last couple of 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 Shortest code to throw SIGILL Why are static password requirements used so frequently? Create a self-extracting archive exe PART 1 Introduction A self-extracting archive is a zip or similar compressed file that has been turned into an exe (executable).
I think one of those two reasons causes the error. Browse other questions tagged microsoft-excel-2010 pivot-table or ask your own question. I have a table with ITEM NAME, COMPANY NAME, QNT, PRICE, LINE PRICE etc as columns. TechBlog by Michael Gerrard.
I appreciate the help. However, no matter what I do, the wizard just tells me that the data source reference is not valid.I have a table with ITEM NAME, COMPANY NAME, QNT, PRICE, LINE PRICE Your name or email address: Do you already have an account? 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
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 Probably because Excel uses square bracket characters to separate the workbook name from a sheet name when storing the reference to a data source, e.g. Pages Home Tips Utilities Errors Linux Backup Excel Photography About Tuesday, 28 February 2012 Excel 2010 - Data source reference is not valid In Excel 2010, when you try to create If you are opening an excel file from a link and don't first save the document, it will say that the pivot table reference is is invalid.