Prev: Remote Access Wizard annoyance
Next: Suggestion on Wireless ADSL Router
From: Brian on 10 Dec 2007 22:03
Installed WSS3 in parallel to WSS2. (SBS 2003 SP2 /w ISA 2004)

When trying to Import Spreadsheet (to WSS3 site, under Site Actions |
Create) I get the error:

Import to Windows SharePoint Services List
Cannot connect to the server at this time. Your table cannot be published.


Isa shows this error:

Closed Connection SERVER 12/10/2007 8:39:42 PM
Log type: Firewall service
Status: A connection was abortively closed after one of the peers sent a RST
segment.
Rule: SBS Protected Networks Access Rule
Source: Internal ( 192.168.16.38:2170)
Destination: Local Host ( 192.168.16.10:21276)
Protocol: Unidentified IP Traffic (TCP:21276)
User:
Additional information
Number of bytes sent: 1313 Number of bytes received: 4710
Processing time: 0ms Original Client IP: 192.168.16.38
Client agent:


Anybody know how to fix this?

Thanks!
Brian

From: Costas on 11 Dec 2007 08:07
Brian,

Did you create a document library to add the spreadsheet? What exactly did
you do after you went to Site Actions | Create ?

--
Costas


"Brian" <Brian(a)discussions.microsoft.com> wrote in message
news:6D5D57F2-BBBD-47A2-8412-6AB0CA62DCE6(a)microsoft.com...
> Installed WSS3 in parallel to WSS2. (SBS 2003 SP2 /w ISA 2004)
>
> When trying to Import Spreadsheet (to WSS3 site, under Site Actions |
> Create) I get the error:
>
> Import to Windows SharePoint Services List
> Cannot connect to the server at this time. Your table cannot be published.
>
>
> Isa shows this error:
>
> Closed Connection SERVER 12/10/2007 8:39:42 PM
> Log type: Firewall service
> Status: A connection was abortively closed after one of the peers sent a
> RST
> segment.
> Rule: SBS Protected Networks Access Rule
> Source: Internal ( 192.168.16.38:2170)
> Destination: Local Host ( 192.168.16.10:21276)
> Protocol: Unidentified IP Traffic (TCP:21276)
> User:
> Additional information
> Number of bytes sent: 1313 Number of bytes received: 4710
> Processing time: 0ms Original Client IP: 192.168.16.38
> Client agent:
>
>
> Anybody know how to fix this?
>
> Thanks!
> Brian
>

From: Brian on 11 Dec 2007 12:28
Costas,

Sorry.. I was tired..

I am trying to Create a 'Custom List', using the 'Import Spreadsheet'
function.
So..
'Site Actions' | 'Create' then under “Custom Lists” | 'Import Spreadsheet'
This opens a “New” window, and I fill out “Name”, “Description”, and “File
location” (the file is on the workstation I am using, on 'The Desktop'). The
“Import” button causes Excel 2007 to open the spreadsheet, and an “Import to
Windows SharePoint Services list” dialog box. I select “Range Type” : 'Table
Range', and “Select Range” : 'A & A!Table1'.
Clicking the 'Import' button produces the error.
Thanks for your help,
Brian


"Costas" wrote:

> Brian,
>
> Did you create a document library to add the spreadsheet? What exactly did
> you do after you went to Site Actions | Create ?
>
> --
> Costas
>
>
> "Brian" <Brian(a)discussions.microsoft.com> wrote in message
> news:6D5D57F2-BBBD-47A2-8412-6AB0CA62DCE6(a)microsoft.com...
> > Installed WSS3 in parallel to WSS2. (SBS 2003 SP2 /w ISA 2004)
> >
> > When trying to Import Spreadsheet (to WSS3 site, under Site Actions |
> > Create) I get the error:
> >
> > Import to Windows SharePoint Services List
> > Cannot connect to the server at this time. Your table cannot be published.
> >
> >
> > Isa shows this error:
> >
> > Closed Connection SERVER 12/10/2007 8:39:42 PM
> > Log type: Firewall service
> > Status: A connection was abortively closed after one of the peers sent a
> > RST
> > segment.
> > Rule: SBS Protected Networks Access Rule
> > Source: Internal ( 192.168.16.38:2170)
> > Destination: Local Host ( 192.168.16.10:21276)
> > Protocol: Unidentified IP Traffic (TCP:21276)
> > User:
> > Additional information
> > Number of bytes sent: 1313 Number of bytes received: 4710
> > Processing time: 0ms Original Client IP: 192.168.16.38
> > Client agent:
> >
> >
> > Anybody know how to fix this?
> >
> > Thanks!
> > Brian
> >
>
From: Costas on 11 Dec 2007 12:59
Brian,

The 'Select Range' element should be 'Sheet1!Table1' . I assume you renamed
'Sheet1' to 'A'. Is that correct? I'm not sure that the 'A &' in front of
the table name is. If selecting the range is not an option (by selecting
'Range of Cells' under 'Range Type') try recreating the table by
highlighting the range and clicking 'table'. Change the name of the columns
and try importing again.

Under 'Select Range' it should should "SheetName!TableName". Importing the
range will be easier but you'll have to rename the default Colum names
within SharePoint after you do that

--
Costas


"Brian" <Brian(a)discussions.microsoft.com> wrote in message
news:3DCA76A4-18FF-42D1-A2A4-33C5283BBB81(a)microsoft.com...
> Costas,
>
> Sorry.. I was tired..
>
> I am trying to Create a 'Custom List', using the 'Import Spreadsheet'
> function.
> So..
> 'Site Actions' | 'Create' then under “Custom Lists” | 'Import Spreadsheet'
> This opens a “New” window, and I fill out “Name”, “Description”, and “File
> location” (the file is on the workstation I am using, on 'The Desktop').
> The
> “Import” button causes Excel 2007 to open the spreadsheet, and an “Import
> to
> Windows SharePoint Services list” dialog box. I select “Range Type” :
> 'Table
> Range', and “Select Range” : 'A & A!Table1'.
> Clicking the 'Import' button produces the error.
> Thanks for your help,
> Brian
>
>
> "Costas" wrote:
>
>> Brian,
>>
>> Did you create a document library to add the spreadsheet? What exactly
>> did
>> you do after you went to Site Actions | Create ?
>>
>> --
>> Costas
>>
>>
>> "Brian" <Brian(a)discussions.microsoft.com> wrote in message
>> news:6D5D57F2-BBBD-47A2-8412-6AB0CA62DCE6(a)microsoft.com...
>> > Installed WSS3 in parallel to WSS2. (SBS 2003 SP2 /w ISA 2004)
>> >
>> > When trying to Import Spreadsheet (to WSS3 site, under Site Actions |
>> > Create) I get the error:
>> >
>> > Import to Windows SharePoint Services List
>> > Cannot connect to the server at this time. Your table cannot be
>> > published.
>> >
>> >
>> > Isa shows this error:
>> >
>> > Closed Connection SERVER 12/10/2007 8:39:42 PM
>> > Log type: Firewall service
>> > Status: A connection was abortively closed after one of the peers sent
>> > a
>> > RST
>> > segment.
>> > Rule: SBS Protected Networks Access Rule
>> > Source: Internal ( 192.168.16.38:2170)
>> > Destination: Local Host ( 192.168.16.10:21276)
>> > Protocol: Unidentified IP Traffic (TCP:21276)
>> > User:
>> > Additional information
>> > Number of bytes sent: 1313 Number of bytes received: 4710
>> > Processing time: 0ms Original Client IP: 192.168.16.38
>> > Client agent:
>> >
>> >
>> > Anybody know how to fix this?
>> >
>> > Thanks!
>> > Brian
>> >
>>

From: Brian on 11 Dec 2007 13:46
Costas,

The sheet was named "A & A". I renamed the sheet to "Sheet1". same probelm.

Changed Table to a Range. same problem.

Also, tried saving the workbook as .xls, .xlsx, and .xlsm same problem.

Brian

"Costas" wrote:

> Brian,
>
> The 'Select Range' element should be 'Sheet1!Table1' . I assume you renamed
> 'Sheet1' to 'A'. Is that correct? I'm not sure that the 'A &' in front of
> the table name is. If selecting the range is not an option (by selecting
> 'Range of Cells' under 'Range Type') try recreating the table by
> highlighting the range and clicking 'table'. Change the name of the columns
> and try importing again.
>
> Under 'Select Range' it should should "SheetName!TableName". Importing the
> range will be easier but you'll have to rename the default Colum names
> within SharePoint after you do that
>
> --
> Costas
>
>
> "Brian" <Brian(a)discussions.microsoft.com> wrote in message
> news:3DCA76A4-18FF-42D1-A2A4-33C5283BBB81(a)microsoft.com...
> > Costas,
> >
> > Sorry.. I was tired..
> >
> > I am trying to Create a 'Custom List', using the 'Import Spreadsheet'
> > function.
> > So..
> > 'Site Actions' | 'Create' then under “Custom Lists” | 'Import Spreadsheet'
> > This opens a “New” window, and I fill out “Name”, “Description”, and “File
> > location” (the file is on the workstation I am using, on 'The Desktop').
> > The
> > “Import” button causes Excel 2007 to open the spreadsheet, and an “Import
> > to
> > Windows SharePoint Services list” dialog box. I select “Range Type” :
> > 'Table
> > Range', and “Select Range” : 'A & A!Table1'.
> > Clicking the 'Import' button produces the error.
> > Thanks for your help,
> > Brian
> >
> >
> > "Costas" wrote:
> >
> >> Brian,
> >>
> >> Did you create a document library to add the spreadsheet? What exactly
> >> did
> >> you do after you went to Site Actions | Create ?
> >>
> >> --
> >> Costas
> >>
> >>
> >> "Brian" <Brian(a)discussions.microsoft.com> wrote in message
> >> news:6D5D57F2-BBBD-47A2-8412-6AB0CA62DCE6(a)microsoft.com...
> >> > Installed WSS3 in parallel to WSS2. (SBS 2003 SP2 /w ISA 2004)
> >> >
> >> > When trying to Import Spreadsheet (to WSS3 site, under Site Actions |
> >> > Create) I get the error:
> >> >
> >> > Import to Windows SharePoint Services List
> >> > Cannot connect to the server at this time. Your table cannot be
> >> > published.
> >> >
> >> >
> >> > Isa shows this error:
> >> >
> >> > Closed Connection SERVER 12/10/2007 8:39:42 PM
> >> > Log type: Firewall service
> >> > Status: A connection was abortively closed after one of the peers sent
> >> > a
> >> > RST
> >> > segment.
> >> > Rule: SBS Protected Networks Access Rule
> >> > Source: Internal ( 192.168.16.38:2170)
> >> > Destination: Local Host ( 192.168.16.10:21276)
> >> > Protocol: Unidentified IP Traffic (TCP:21276)
> >> > User:
> >> > Additional information
> >> > Number of bytes sent: 1313 Number of bytes received: 4710
> >> > Processing time: 0ms Original Client IP: 192.168.16.38
> >> > Client agent:
> >> >
> >> >
> >> > Anybody know how to fix this?
> >> >
> >> > Thanks!
> >> > Brian
> >> >
> >>
>
 |  Next  |  Last
Pages: 1 2 3
Prev: Remote Access Wizard annoyance
Next: Suggestion on Wireless ADSL Router