excel error data source not valid Cochran Georgia

Secure technologies. Security compliance and network installation are OUR core services.

Address Milan, GA 31060
Phone (478) 220-8130
Website Link https://securityfoundation.net

excel error data source not valid Cochran, Georgia

Unwarranted censorship Recently, I have been getting this error messge when I try to create a Pivot Table from Table in excel 2007. Register Privacy Policy Terms and Rules Help Popular Sections Tech Support Forums Articles Archives Connect With Us Twitter Log-in Register Contact Us Forum software by XenForo™ ©2010-2016 XenForo Ltd. I removed the square brackets totally by chance and found the pivots are working. Translating "machines" and "people" If Dumbledore is the most powerful wizard (allegedly), why would he work at a glorified boarding school?

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 {{offlineMessage}} Store Store home Devices Microsoft Surface PCs & tablets Xbox Virtual reality Accessories Windows phone Software Office Windows Additional software Apps All apps Windows apps Windows phone apps Games Xbox FreeNAS - first time setup Introduction NAS means Network Attached Storage. The time now is 03:54 AM.

I think one of those two reasons causes the error. to enable the pivot to function. Click on HOME> PREPARE> INSPECT DOCUMENT> Removed all unneccesary references and xml forms. 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.

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. Are the field names too long (over 255 characters in Excel 2003)? #3 Check that the named range underlying the pivot table is not broken Use the wizard or the ribbon Thanks for your hlep! Advertisements Latest Threads WCG Stats Saturday 15 October 2016 WCG Stats posted Oct 15, 2016 at 8:00 AM Review round up - 14 October 2016 Becky posted Oct 14, 2016 at

Excel 2013 and 2010, probably earlier versions too - feel free to write in the comments below about your experiences. Olly Oliver Marshall, Nov 17, 2007 #1 Advertisements Roger Govier Guest Hi Olly I have had no difficulty running any of my Xl2003 Pivots in XL2007. 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 When I save it somewhere with the same filename it just works!

Submit your problem here, or add a comment below. 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 http://mgxp.blogspot.ch/2014/07/excel-refresh-data-for-pivot-table.html Conclusion If you are using tables with pivot tables and you update the data you may have this problem. I found that the Excel file from my web-based reporting tool was not actually in XLSX format.

Are there any hidden columns in the data that might have blank named fields? Generated Sat, 15 Oct 2016 09:48:09 GMT by s_wx1131 (squid/3.5.20) Skip to content Excel Girl Fast, Friendly Excel Help Menu Excel Consultation Excel Training About Contact Pivot table data source not Which method you choose is up to you. Just click the sign up button to choose a username and then you can ask your own questions on the forum.

If the latter, what name? Solution Click on the sheet where the data/table is If it's formatted as a table check the table name - on the far left Change to the sheet where the pivot Likes (0) Quote Replies Please login or register to join the discussion. No, create an account now.

Sign Up Now! Required fields are marked *Write your comment here:Your comment will only be published after moderation approval.Your Name: * Your Email (will only be used for your Gravatar): * Search for: Categories Then re-open and it should work. 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

My AccountSearchMapsYouTubePlayNewsGmailDriveCalendarGoogle+TranslatePhotosMoreShoppingWalletFinanceDocsBooksBloggerContactsHangoutsEven more from GoogleSign inHidden fieldsSearch for groups or messages Get our best content sent straight to your inbox. like this: C:\Folder\[SomeWorkbookName.xlsx]Sheet1!A1:Z1000 When a workbook already contains square bracket characters in the filename this probably messes things up for Excel and triggers the error message. shiro, Aug 22, 2007, in forum: Microsoft Excel Discussion Replies: 0 Views: 193 shiro Aug 22, 2007 reference is not valid message for pivot tables based on Access query Doug Glancy, 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

Please try the request again. The solution to the problem is to save your workbook (or rename the workbook file) using another filename that does not contain the square bracket characters. StevieG StevieGarner, Mar 22, 2011 #5 Guest On Saturday, November 17, 2007 10:35:58 AM UTC-8, Oliver Marshall wrote: > Weirdest thing. Oliver Marshall Guest Hi, I'm trying to create a pivot table in Excel 2007, something I have done a thousand times in 2003.

You'll get the same error "Data Source Reference Not Valid". I saved it with a new file name (sales1.xlsx rather > than sales.xlsx) and it worked just fine !! > > How odd. > > > Ta anyway I had the 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 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

The system returned: (22) Invalid argument The remote host or network may be down. 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?