Prev: Remote Access Wizard annoyance
Next: Suggestion on Wireless ADSL Router
From: Costas on 11 Dec 2007 14:11
Brian,

The problem doesn't seem to be with the SpreadSheet or SharePoint. It is
ISA related and I don't have an answer right now. I'll do some research and
get back to you.

--
Costas


"Brian" <Brian(a)discussions.microsoft.com> wrote in message
news:13A17012-489B-4529-BF4F-FF2EF84BAD14(a)microsoft.com...
> 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
>> >> >
>> >>
>>

From: Costas on 11 Dec 2007 14:37
Brian,

How do you try to access the site? Do you use http or https? Do you use an
internal name (http://site) or an the full domain? Is 21276 the port of
your site? Do you have anything listening to port 2170?

--
Costas


"Costas" <cpstechgroup(a)gmail.com> wrote in message
news:AB71FF98-30A6-4403-8448-52FBF0D80CDB(a)microsoft.com...
> Brian,
>
> The problem doesn't seem to be with the SpreadSheet or SharePoint. It is
> ISA related and I don't have an answer right now. I'll do some research
> and get back to you.
>
> --
> Costas
>
>
> "Brian" <Brian(a)discussions.microsoft.com> wrote in message
> news:13A17012-489B-4529-BF4F-FF2EF84BAD14(a)microsoft.com...
>> 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
>>> >> >
>>> >>
>>>
>

From: Brian on 11 Dec 2007 15:16
Costas,

http://newcompanyweb:21276/sites/NewCompanyWeb/default.aspx

Yes.. looks like site uses port 21276.

Didn't see 2170 listed when I ran netstat -ano on the server or
worksation.

Brain


"Costas" wrote:

> Brian,
>
> How do you try to access the site? Do you use http or https? Do you use an
> internal name (http://site) or an the full domain? Is 21276 the port of
> your site? Do you have anything listening to port 2170?
>
> --
> Costas
>
>
> "Costas" <cpstechgroup(a)gmail.com> wrote in message
> news:AB71FF98-30A6-4403-8448-52FBF0D80CDB(a)microsoft.com...
> > Brian,
> >
> > The problem doesn't seem to be with the SpreadSheet or SharePoint. It is
> > ISA related and I don't have an answer right now. I'll do some research
> > and get back to you.
> >
> > --
> > Costas
> >
> >
> > "Brian" <Brian(a)discussions.microsoft.com> wrote in message
> > news:13A17012-489B-4529-BF4F-FF2EF84BAD14(a)microsoft.com...
> >> 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
> >>> >> >
> >>> >>
> >>>
> >
>
From: Costas on 11 Dec 2007 16:00
Brian,

Check Internet Explorer | Internet Options | Connections | LAN settings. If
there is a proxy server used, uncheck the checkbox and see if that solves
the problem.

I'm not sure if that would be a permanent solution (assuming it helps) but I
can't find much info on this type of error. My business server runs ISA and
WSS 3.0 in parallel to WSS 2.0 and I tested your issue but I couldn't
replicate it.

--
Costas


"Brian" <Brian(a)discussions.microsoft.com> wrote in message
news:EAF40D09-C6DA-4C46-AA94-9A54E3870A16(a)microsoft.com...
> Costas,
>
> http://newcompanyweb:21276/sites/NewCompanyWeb/default.aspx
>
> Yes.. looks like site uses port 21276.
>
> Didn't see 2170 listed when I ran netstat -ano on the server or
> worksation.
>
> Brain
>
>
> "Costas" wrote:
>
>> Brian,
>>
>> How do you try to access the site? Do you use http or https? Do you use
>> an
>> internal name (http://site) or an the full domain? Is 21276 the port of
>> your site? Do you have anything listening to port 2170?
>>
>> --
>> Costas
>>
>>
>> "Costas" <cpstechgroup(a)gmail.com> wrote in message
>> news:AB71FF98-30A6-4403-8448-52FBF0D80CDB(a)microsoft.com...
>> > Brian,
>> >
>> > The problem doesn't seem to be with the SpreadSheet or SharePoint. It
>> > is
>> > ISA related and I don't have an answer right now. I'll do some
>> > research
>> > and get back to you.
>> >
>> > --
>> > Costas
>> >
>> >
>> > "Brian" <Brian(a)discussions.microsoft.com> wrote in message
>> > news:13A17012-489B-4529-BF4F-FF2EF84BAD14(a)microsoft.com...
>> >> 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
>> >>> >> >
>> >>> >>
>> >>>
>> >
>>

From: Brian on 11 Dec 2007 18:39
Costas,

Unchecked 'proxy'.. same problem. (also, 'Bypass proxy for local addresses
had been checked).
At this point (not actually using WSS3) I am open to reinstalling, and even
other configurations..

What do you think about this:
http://msmvps.com/blogs/cgross/archive/2007/02/04/companyweb-sharepoint-v3-part-5.aspx
I am trying this out on a test box.. but I am not sure I want to go with
an unsupported configuration on a production box. Although, it seems that
the original companyweb could be side stepped [if the /Remote site was
edited to link to a NewCompanyweb; and if internal IE browsers were pointed
at the NewCompanyweb for homepage] with no change to the original companyweb
site.

Also, Is this:
http://msmvps.com/blogs/cgross/archive/2007/05/28/using-your-sql-in-sbs-r2-premium-as-a-back-end-for-wss-3-0.aspx
a supported configuration? (SBS 2003 SP2 /w SQL 2000)

Thanks,
Brian


"Costas" wrote:

> Brian,
>
> Check Internet Explorer | Internet Options | Connections | LAN settings. If
> there is a proxy server used, uncheck the checkbox and see if that solves
> the problem.
>
> I'm not sure if that would be a permanent solution (assuming it helps) but I
> can't find much info on this type of error. My business server runs ISA and
> WSS 3.0 in parallel to WSS 2.0 and I tested your issue but I couldn't
> replicate it.
>
> --
> Costas
>
>
> "Brian" <Brian(a)discussions.microsoft.com> wrote in message
> news:EAF40D09-C6DA-4C46-AA94-9A54E3870A16(a)microsoft.com...
> > Costas,
> >
> > http://newcompanyweb:21276/sites/NewCompanyWeb/default.aspx
> >
> > Yes.. looks like site uses port 21276.
> >
> > Didn't see 2170 listed when I ran netstat -ano on the server or
> > worksation.
> >
> > Brain
> >
> >
> > "Costas" wrote:
> >
> >> Brian,
> >>
> >> How do you try to access the site? Do you use http or https? Do you use
> >> an
> >> internal name (http://site) or an the full domain? Is 21276 the port of
> >> your site? Do you have anything listening to port 2170?
> >>
> >> --
> >> Costas
> >>
> >>
> >> "Costas" <cpstechgroup(a)gmail.com> wrote in message
> >> news:AB71FF98-30A6-4403-8448-52FBF0D80CDB(a)microsoft.com...
> >> > Brian,
> >> >
> >> > The problem doesn't seem to be with the SpreadSheet or SharePoint. It
> >> > is
> >> > ISA related and I don't have an answer right now. I'll do some
> >> > research
> >> > and get back to you.
> >> >
> >> > --
> >> > Costas
> >> >
> >> >
> >> > "Brian" <Brian(a)discussions.microsoft.com> wrote in message
> >> > news:13A17012-489B-4529-BF4F-FF2EF84BAD14(a)microsoft.com...
> >> >> 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
> >> >>> >> >
> >> >>> >>
> >> >>>
> >> >
> >>
>
First  |  Prev  |  Next  |  Last
Pages: 1 2 3
Prev: Remote Access Wizard annoyance
Next: Suggestion on Wireless ADSL Router