Sharepoint Forum

Ask Question   UnAnswered
Home » Forum » Sharepoint       RSS Feeds

Can't Create a Custom Import Spreadsheet

  Asked By: Kimberlee    Date: Mar 13    Category: Sharepoint    Views: 8737

Cannot create a new list using the Create->Import Spreadsheet. Imediately get An
unexpected error has occurred. A few posts talk about the modifyig the
EXPTOOWS.XLA but I can't find any version of the file that contains Dim

Another post talks about adding the site as a Trusted Site.

Any ideas?



5 Answers Found

Answer #1    Answered By: Abinav Basu     Answered On: Mar 13

I've not heard experienced or heard of trouble with this particular
operation, but I'm familiar with the Trusted site  bit (when you're trying to
avoid endless login prompts). If you're using IE 6, you want to add the SP
site to your Trusted Sites zone; if IE 7 or above, then add it to Local

The error  you're describing doesn't seem to be a versioning problem. Have
you checked the application logs (via Event Viewer) and the SP logs in the
12 hive?

Answer #2    Answered By: Teresa Simpson     Answered On: Mar 13

If you are using WSS 3.0 or MOSS 2007 and if you are using Excel 2007 I
learned that you need to format your list  as a Table from the Styles
group on the Home tab of the Ribbon with a Table Name which can then be

Answer #3    Answered By: Robby Barr     Answered On: Mar 13

There were no entries in any of the 12 hive logs nor anything in the Event logs
on the portal. My local App log has:
Faulting application excel.exe, version  12.0.6331.5000, stamp 48fa2869, faulting
module kernel32.dll, version 5.1.2600.5512, stamp 4802a12c, debug? 0, fault
address 0x00012aeb.

Haven't been able to find  any solutions.

Answer #4    Answered By: Patrick Davis     Answered On: Mar 13

Tried that but still no luck..............

Answer #5    Answered By: Alexander Rocha     Answered On: Mar 13

I found a work around:

Using Excel 2007, format the data as a table, then under the Design tab on the
ribbon, use the Export (External Table Data) to PUSH it from Excel to MOSS,
instead of PULLING.

It doesn't solve the original problem but it works.

Didn't find what you were looking for? Find more on Can't Create a Custom Import Spreadsheet Or get search suggestion and latest updates.