Error Data Source Reference Is Not Valid Pivot Table Excel 2010
Thanks for your hlep! Milo , Sep 17, 2012 #8 Guest On Wednesday, December 19, 2007 7:01:01 AM UTC-6, Bart wrote: > Maybe it has to do when you are opening the excel file I appreciate the help. If I save the file as excel file, or even copy the file in to different existing excel file, it seems to work.
I need to save under a new file name in xlsx. 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  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: 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.
Destination Reference Is Not Valid Pivot Table
I have checked every single column and there is no empty one. This issue may be seen when trying to open an Excel workbook from Internet Explorer. Hot topics Sub-categories Self assessment European Union Making tax digital Self assessment Accounts reported in wrong tax year Self assessment Tax charge on Pension lump sum - tax return entry? All rights reserved.
- 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
- PC Review Home Newsgroups > Microsoft Excel > Microsoft Excel Discussion > Home Home Quick Links Search Forums Recent Posts Forums Forums Quick Links Search Forums Recent Posts Articles Articles Quick
- Is the range defined by cell references or by a range name?
- Reply Phong Jan 11 I encountered this same problem.
Try again with Data>Insert table>give it a different name>then with cursor within the table>Data>Options>Create Pivot Table. However, no matter what I do, the wizard just tells me that the data source reference is not valid. Reply Chris Sep 23 Yep, I exported to a spreadsheet from a web-based report and got the error. Excel Reference Is Not Valid Stuck Do you have a Word document that has grey square brackets [ ] in it that you can't delete no matter what you do?
If you get a chance could you please help me to fix this as soon as you can. Pivot Table Error Field Name Is Not Valid I saved it with a new file name (sales1.xlsx rather > > than sales.xlsx) and it worked just fine !! > > > > How odd. > > > > > Too many reports because report button is too convenient Why is nuclear waste more dangerous than the original nuclear fuel? All contents Copyright 1998-2016 by MrExcel Consulting.
Then re-open and it should work. Invalid Excel Characters 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. 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 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.
Pivot Table Error Field Name Is Not Valid
When I converted to Excel 2007 I started getting this error message. 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 Destination Reference Is Not Valid Pivot Table Are you sure you don't have any hidden un-named columns? Reference Is Not Valid Excel 2010 About Us PC Review is a computing review website with helpful tech support forums staffed by PC experts.
I saved it with a new file name (sales1.xlsx rather > > than sales.xlsx) and it worked just fine !! > > > > How odd. > > > > > I saved it with a new file name (sales1.xlsx rather > than sales.xlsx) and it worked just fine !! > > How odd. > > > Ta anyway > Bart, Thanks for the tip! , Jul 23, 2012 #6 Guest I had the same issue. When you save it locally it changes to read/write and creating pivots start to work again. , Oct 10, 2012 #9 Dan Guest On Wednesday, December 19, 2007 5:01:01 AM Data Source Reference Is Not Valid Power Map
I have been downloading out of a main data warehouse and trying to create a pivot directly off the download. Select from Table instead from range. It's an easy way to quickly add disk space to a network, without the need for installi... Especially if you have had no trouble creating a PivotTable before using the same or a similar data source range.
Member Login Remember Me Forgot your password? Excel Reference Is Not Valid Cannot Quit Reply Leave a Reply Click here to cancel reply. 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.
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
Awesome Inc. Likes (0) Quote Replies Please login or register to join the discussion. Thanks (0) Please login or register to join the discussion. Reference Is Not Valid Excel Hyperlink Share: Category: Problem Solving Tags: Error Messages, PivotTable Post navigation ← Retrieve A Worksheet Based On The Worksheet Contents Import Data From Multiple Workbooks → Leave a comment: Cancel reply Your
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 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 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 If I also convert my data in to a range and try to insert PT, I get the same error.
Tax Tolley's Tax Hub Practice Sub-categories Practice strategy General practice Skills Practice strategySponsored 7 referral systems for generating more clients Practice strategy MTD "fall out" has already started Practice strategySponsored Don't Home Tax Sub-categories Personal tax Business tax HMRC & policy Tax MTD: The impact on your accounting firm and... This can be avoided by clicking "Save," instead of "Open," when Internet Explorer presents the file tothe user. , Jan 8, 2014 #18 Guest Important safety tip: if you're also 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.
Reply Jeremy Collins Aug 9 Check to also see if the workbook is protected. Why? When I did a "Save As" in Excel the file type was "Web page". Had the same problem. "Oliver Marshall" wrote: > Weirdest thing.
The original spreadsheet was downloaded from the internet and it seems that excel throws up this error if you try to run the pivot table while the spreadsheet is stored in Shortest code to throw SIGILL Why are static password requirements used so frequently? Frustrating really. Who/What is "Concerned Citizen" in The Witcher 3?
Japanese Mahjong Score Calculator What happens if BB-8 rolls the wrong way? Word 2010 - can't get rid of grey square brackets? Posted by Michael Gerrard at 20:04 Reactions: Email ThisBlogThis!Share to TwitterShare to FacebookShare to Pinterest Labels: error, Excel, Office Post a Comment Newer Post Older Post Home Subscribe to: Post Comments Finding Residue Does Harley Quinn ever have children?
I tried this at Office desktop as well as Laptop. Click on HOME> PREPARE> INSPECT DOCUMENT> Removed all unneccesary references and xml forms. Is the Pivot table picking up the correct range?