Home > Unexpected Error > Sharepoint 2010 Import Spreadsheet Error

Sharepoint 2010 Import Spreadsheet Error


Which kind of "ball" was Anna expecting for the ballroom? I ran into an error today where when I attempted to import a spreadsheet into a list I was told "The specified file is not a valid spreadsheet or contains no Tags BPOS SharePoint Comments (16) Cancel reply Name * Email * Website Anonymous says: October 27, 2016 at 3:25 pm You saved me from big trouble. In doing so I am transferring all the data over and ran into this issue. http://ipodcorrectors.com/unexpected-error/sharepoint-2010-import-spreadsheet-unexpected-error.php

Ive already googled and binged as much as possible and have been unable to resolve this issue. Click here for more information SharePoint Articles ↓ SharePoint 2016 SharePoint 2013 SharePoint 2010 SharePoint Apps Workflow WebPart InfoPath SharePoint Object Model PowerShell Search SharePoint Designer MasterPage & Page Layout List THANKS! Usually it's a case of the site having default US settings (of mm/dd/yy) when all sensible societies use dd/mm/yy. | You have posted to a forum that requires a moderator to http://sharepoint.stackexchange.com/questions/61326/sharepoint-2010-error-when-importing-excel-spreadsheet-to-sharepoint-list

Sharepoint 2013 Import Spreadsheet An Unexpected Error Has Occurred

Add Cancel × Insert code Language Apache AppleScript Awk BASH Batchfile C C++ C# CSS ERB HTML Java JavaScript Lua ObjectiveC PHP Perl Text Powershell Python R Ruby Sass Scala SQL Setup: I am using Excel 2010, Windows 7, IE 8, SharePoint Server 2010 which are all loaded on a Windows 7 laptop. Reply Follow UsPopular TagsSharePoint SharePoint Designer Pages BPOS Mapping Archives June 2009(1) May 2009(3) April 2009(7) All of 2009(11) Privacy & Cookies Terms of Use Trademarks © 2016 Microsoft TechCenter  

Reply rajesh says: May 19, 2014 at 2:43 pm Solved Reply Prashant Kaushik says: June 19, 2015 at 6:57 pm If after adding your site as a trusted site is also Posted: over 1 year ago by Hassan Zaidi Share this: I think you have 64 bit OS and you are using office 32 bit version. Reply Mell says: October 9, 2013 at 4:02 pm Thanks this fixed my issue with importing spreadsheet!!! The Selected Range Cannot Be Converted To A Table Before Publishing You can drop the content database from 2007 and bring it over to 2010. 0 Serrano OP Jon.P Jul 31, 2012 at 12:54 UTC Ive been manually moving

Office UI Fabric Microsoft Graph Better with Office Word Excel Powerpoint Access Project OneDrive OneNote Outlook SharePoint Skype Yammer Android ASP .NET iOS JavaScript Node.js PHP (coming soon) Python (coming soon) Method 'post' Of Object 'iowspostdata' Failed Reply Anonymous says: October 27, 2016 at 3:25 pm My lowest security setting that is available is medium-low. Is that why I am still getting this error? Can anyone assist please | You have posted to a forum that requires a moderator to approve posts before they are publicly available.

I've ignored it since it wasn't a big deal right now...but maybe I should be looking closer at it. 0 Mace OP Helpful Post Denis Kelley Jul 31, Sharepoint Import Excel Unexpected Error And whenever you see a reply being an answer to the question of the thread, click "Mark As Answer

Marked as answer by Maggy111 Tuesday, November 06, 2012 8:48 AM Monday, Join Now Deets: Sharepoint 2010 & Office 2010 I have been given the "awesome" opportunity to revamp and upgrade our 2007 sharepoint site to 2010. See all articles SharePoint Tag Cloud Administration (23) AngularJS SharePoint (3) Backup and Restore (13) Books (3) Business Conectivity Services (10) CAML and LINQ (10) Central Administration (3) Development (7) Downloads

Method 'post' Of Object 'iowspostdata' Failed

I followed these directions: dummies.com/how-to/content/… –Remy Mar 7 '13 at 11:08 add a comment| 3 Answers 3 active oldest votes up vote 2 down vote accepted Well, I searched some more When adding it, the message is "sites added to this zone must have https in the prefix". Sharepoint 2013 Import Spreadsheet An Unexpected Error Has Occurred Thank you!!! Sharepoint Import Spreadsheet Unexpected Error When I select Site Actions > More Options > Import Spreadsheet  > Select my excel doc and cell range and when I select Import I get "An Unexpected error has occurred.

SharePoint OpenDocuments Class add-on is responsible with that communication between the browser and the SharePoint site. Check This Out How to see the name of the command everytime I run it by a shortcut? You solved my problem in a minute.. I am using IE8. Sharepoint 2010 Import Spreadsheet An Unexpected Error Has Occurred

I am Microsoft Office Servers and Services (SharePoint) MVP (3 times). I wish there was a way to convert back to sharepoint 2007!!! Help Desk » Inventory » Monitor » Community » NYIM Training Blog Software Training Search Main menu Skip to primary content Skip to secondary content Return to Training Excel Classes PowerPoint Source Privacy statement Community Resources O365 Technical Network MSDN Forums UserVoice Stack Overflow Follow Us Twitter Facebook Office Dev Blog © 2016 Microsoft United States - English Terms of Use Trademarks Privacy

asked 3 years ago viewed 11276 times active 5 months ago Related 3possible ways to import an excel spreadsheet to a sharepoint 2010 list?1Import from Excel Spreadsheet works in IE6 not Unexpected Error Importing Spreadsheet Sharepoint 2010 My hosted site does not have that. Should I use the formal form (~ます) on the buttons of an app?

Then I used the specific web address i was using to access Sharepoint and added it to the trusted sites and it worked.

What about the data and the columns. This saved me having to re-enter all my columns. 🙂 Reply Prashant Shrivas says: January 11, 2016 at 11:01 am Was very helpful info. See all article comments Subscription Subscribe by e-mail address to receive latest news and updates. Import To Windows Sharepoint Services List Method Post Of Object Iowspostdata Failed Thanks!

Tab. (This was already automatically done for me). this can be caused if you're importing dates and your SP regional settings don't match the date format of what you're importing. And then in the "Select a zone to view... ", click Trusted Sites. have a peek here NYIM PowerPoint Group Class Training $50 Off for 9/21/16 and 9/22/16 Only!

Join the community Back I agree Powerful tools you need, all for free. I am using IE8 and Office 2007 and SharePoint Foundation (WSS4.0). Reply Subscribe View Best Answer RELATED TOPICS: Sharepoint 2010 going down every morning SharePoint 2010 Error 401 Unauthorized when using "Save As" Sharepoint 2010 - Subsite gives an error   8 Then reload the webpage, and it should load fine.

This worked for me. All is well now and everything is working. current community chat SharePoint SharePoint Meta your communities Sign up or log in to customize your list. Email check failed, please try again Sorry, your blog cannot share posts by email. %d bloggers like this: About us | Contact us | Advertise | Login | New User?

Posted: over 2 years ago by reema bhingarde Share this: Please check the system specification Windows 7/8 Enterprise 32/64 bit; Office version and 32/64 bit; Internet Explorer Thanks a lot ! By creating an account, you're agreeing to our Terms of Use and our Privacy Policy Not a member? Changes to your data cannot be saved." Ive tried this with a spreadsheet with 700 items, and one with as little as 4 items, and its the same error every time.

http://social.msdn.microsoft.com/Forums/sharepoint/en-US/d04e049f-dcc6-4b8e-a3dd-817b3adfcccc/error-the-specified-file-is-not-a-valid-spreedsheet-or-contains-no-data-to-import-in-sharepoint http://hellebuyck.net/?p=123Please remember to mark your question as answered &Vote helpful,if this solves/helps your problem. ****************************************************************************************** Thanks -WS MCITP(SharePoint 2010, 2013) Blog: http://wscheema.com/blog Marked as answer by pgg02 Saturday, November 09, Creating your account only takes a few minutes.