Microsoft KB Archive/838703

= You receive a &quot;Cannot connect to server at this time. Your list cannot be published&quot; error message when you import an Excel spreadsheet to use as a basis for a new list in Windows SharePoint Services =

Article ID: 838703

Article Last Modified on 9/26/2007

-

APPLIES TO


 * Microsoft Windows SharePoint Services

-





SUMMARY
''This article describes an issue in Microsoft Windows SharePoint Services, where you receive a &quot;Cannot connect to the server at this time. Your list cannot be published&quot; error message when you create a new list in the Web site, and the list is based on a Microsoft Excel spreadsheet. You receive this error message when you try to import the Excel spreadsheet to Windows SharePoint Services to use for the new list. This article describes two methods that you can use to work around this problem.''



SYMPTOMS
When you create a new list in your Windows SharePoint Services Web site, and you try to import an Excel spreadsheet to use as a basis for the new list, you may receive the following error message:

Cannot connect to the server at this time. Your list cannot be published.



CAUSE
This problem occurs because of an issue between Windows SharePoint Services and Excel that prevents the Excel spreadsheet from being imported correctly to Windows SharePoint Services when you create a new list. This problem may occur if the Web site is configured to use Anonymous access.



WORKAROUND
To work around this problem, use one of the following methods, depending on your situation.

If your Web site is hosted by an ISP and Windows SharePoint Services uses Active Directory account creation mode
If your Web site is hosted by an Internet Service Provider (ISP) and Windows SharePoint Services was installed by using Active Directory account creation mode, you experience the symptoms that are described in the &quot;Symptoms&quot; section when you try to create a list in a subsite. To work around this problem, create a new list that is based on the Excel workbook that is located in the root site, save the list as a list template, and then create the list that you want in the subsite from the new list template that you created. To do so, follow these steps:  In the root site, create a new list that is based on the Excel workbook. To do so, follow these steps:  On the home page of the root site, click Create. On the Create page, under Custom Lists, click Import Spreadsheet. Specify the options that you want, and then click Import. In the Import to Windows SharePoint Services list dialog box, click the range of cells that you want to use for your list, and then click Import. Specify the columns and the rows that you want to import, and then click Import.</li></ol> </li> In the root site, save the new list that you created as a list template. To do so, follow these steps: <ol style="list-style-type: lower-alpha;"> In the root site, click Documents and Lists.</li> Click the link to the list that you want to save as a template.</li> Click Modify settings and columns.</li> On the Customize  page, under General Settings, click Save list as template.</li> In the File name box, type the file name that you want to use for the template file.</li> In the Template title box, type the title that you want to use for the template.</li> Click to select the Include content check box.</li> Click OK.</li></ol> </li> Connect to the subsite, and then create a new list that is based on the new list template that you created in step 2. To do so, follow these steps: <ol style="list-style-type: lower-alpha;"> Connect to the subsite, and then click Create.</li> Click the template that you created in step 2.</li> On the New List page, specify a name and a description for the list, and then click Create.</li></ol> </li></ol>

If Windows SharePoint Services does not use Active Directory account creation mode
If Windows SharePoint Services was not installed by using Active Directory account creation mode, you experience the symptoms that are described in the &quot;Symptoms&quot; section in the root site. To work around this problem, temporarily disable Anonymous access settings on the Web site, create a new list that is based on the Excel workbook that is located in the root site, save the list as a list template, create the list that you want from the new list template that you created, and then enable Anonymous access settings on the Web site. To do so, follow these steps: <ol> Disable Anonymous access settings on the Web site in Windows SharePoint Services. To do so, follow these steps: <ol style="list-style-type: lower-alpha;"> On the home page of the root site, click Site Settings.</li> <li>On the Site Settings page, click Go to Site Administration.</li> <li>On the Top-level Site Administration page, under Users and Permissions, click Manage anonymous access.</li> <li>On the Change Anonymous Access Settings:  page, in the Anonymous Access area, click Nothing.</li> <li>Click OK.</li></ol> </li> <li>Create a new list that is based on the Excel workbook. To do so, follow these steps: <ol style="list-style-type: lower-alpha;"> <li>Click Create.</li> <li>On the Create page, under Custom Lists, click Import Spreadsheet.</li> <li>Specify the options that you want, and then click Import.</li> <li>In the Import to Windows SharePoint Services list dialog box, click the range of cells that you want to use for your list, and then click Import.</li> <li>Specify the columns and the rows that you want to import, and then click Import.</li></ol> </li> <li>Save the new list that you created as a list template. To do so, follow these steps: <ol style="list-style-type: lower-alpha;"> <li>Click Documents and Lists.</li> <li>Click the list that you created in step 2.</li> <li>Click Modify settings and columns.</li> <li>On the Customize  page, under General Settings, click Save list as template.</li> <li>On the Save as Template:  page, in the File name box, type the file name that you want to use for the template file.</li> <li>In the Template title box, type the title that you want to use for the template.</li> <li>Click to select the Include content check box, and then click OK.</li></ol> </li> <li>Create a new list that is based on the new list template that you created in step 2. To do so, follow these steps: <ol style="list-style-type: lower-alpha;"> <li>Click Create.</li> <li>Click the template that you created in step 3.</li> <li>On the New List page, specify a name and a description for the list, and then click Create.</li></ol> </li> <li>Configure Anonymous access settings on the Web site in Windows SharePoint Services. To do so, follow these steps: <ol style="list-style-type: lower-alpha;"> <li>On the home page of the root site, click Site Settings.</li> <li>On the Site Settings page, click Go to Site Administration.</li> <li>On the Top-level Site Administration page, under Users and Permissions, click Manage anonymous access.</li> <li>On the Change Anonymous Access Settings:  page, in the Anonymous Access area, click Entire Web site or click Lists and libraries, depending on your situation</li> <li>Click OK.</li></ol> </li></ol>

<div class="status_section">

STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the &quot;Applies to&quot; section.

<div class="moreinformation_section">

MORE INFORMATION
For more information about Windows SharePoint Services, visit the following Microsoft Web site:

http://technet.microsoft.com/windowsserver/sharepoint/default.aspx

Keywords: kbprb kbtshoot kbimport kbnewfile kbwebservices kberrmsg kbpending KB838703

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.