Home > Sharepoint > Error “the selected range cannot be converted to a table..” When Import from Spreadsheet

Error “the selected range cannot be converted to a table..” When Import from Spreadsheet

I got This Error :

image

When Creating List from Spreadsheet. Then after sometimes of trying, I’ve found out that Error won’t happened when I removed the Formula. The trick to remove formula in Excell is just copy and paste to other sheet with option Values when pasting (as seen below), then use that pasted sheet for importing.

image

Categories: Sharepoint Tags:
  1. No comments yet.
  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: