software

I am using Excel 2003

I have selected in the propertoes tab quot;insert entire rows for new data,
clear unused cellsquot;, yet when I refresh with changed data, the new data is
there but new rows are not being added. I have tried this numerous times
using a variety of the check boxes, including quot;fill down formulas in adjacent
columnsquot; to no avail.

Here is what I am trying to do, in case there is a better way:

I want to have a spreadsheet with 12 monthly worksheets and one YTD
worksheet. As I added new items to the inventory, I want to update each of
these worksheets to reflect the new items. Most of the time the new items
will be in between existing items.

What I have done is prepared two spreadsheets, one with the monthly and YTD
workbooks and another with only the inventory listing. Refresh works
properly as far as adding the new item, but it is not adding a complete line
for the data, such that each new item quot;capturesquot; cells to the right of it
which is data for the item which is now beneath it, causing my last item to
be one row off for each new inventory added.

I am also open to having all the data come from within one spreadsheet.

Thanks in advance for any thoughts, ideas or suggestions!

Rental Man

hi,
I think you left out something before selecting the properties tab.
Which properties tab?
But by what you said after leads me to think you are trying to use microsoft
query to refresh or updata a table or named range. if not, ignore this post.
if your data is skued after refresh then i would guess that the table or
named range is too small and does not cover all of your table data. Try
resetting your table.
high light your data then on the menu bar click
insertgt;namegt;define.
you may have to reset more than one table.

regards
FSt1
quot;Rental Manquot; wrote:

gt; I am using Excel 2003
gt;
gt; I have selected in the propertoes tab quot;insert entire rows for new data,
gt; clear unused cellsquot;, yet when I refresh with changed data, the new data is
gt; there but new rows are not being added. I have tried this numerous times
gt; using a variety of the check boxes, including quot;fill down formulas in adjacent
gt; columnsquot; to no avail.
gt;
gt; Here is what I am trying to do, in case there is a better way:
gt;
gt; I want to have a spreadsheet with 12 monthly worksheets and one YTD
gt; worksheet. As I added new items to the inventory, I want to update each of
gt; these worksheets to reflect the new items. Most of the time the new items
gt; will be in between existing items.
gt;
gt; What I have done is prepared two spreadsheets, one with the monthly and YTD
gt; workbooks and another with only the inventory listing. Refresh works
gt; properly as far as adding the new item, but it is not adding a complete line
gt; for the data, such that each new item quot;capturesquot; cells to the right of it
gt; which is data for the item which is now beneath it, causing my last item to
gt; be one row off for each new inventory added.
gt;
gt; I am also open to having all the data come from within one spreadsheet.
gt;
gt; Thanks in advance for any thoughts, ideas or suggestions!
gt;
gt; Rental Man

I am accessing the external data as follows:

Data --gt; Import external data --gt; import data --gt; new source --gt; ODBC SAN
--gt; excel files --gt; excel file name --gt; select a table from the list, such as
NAMES (connect to spefici table is checked) --gt; name the external link --gt;
click finish --gt; import data box pops up --gt; select properties button on the
bottom --gt; select quot;insert entire rows for new data, clear unused cellsquot; and
quot;fill down formulas in adjacent rowsquot;

Despite doing what appears to be correct, when I add a line to my external
data, it does not add a new row to the workbook. It will insert the new
data, but all information in the row to the right remains unchanged and the
bottom row of data is now quot;orphanedquot; without data to the right

example

row 1 data 1
row 2 data 2
row 3 data 3

becomes:
row 1 data 1
row 2 data 2
new 1 data 3
row 3

when is should become:

row 1 data 1
row 2 data 2
new 1
row 3 data 3

Hope this helps clarify.
quot;FSt1quot; wrote:

gt; hi,
gt; I think you left out something before selecting the properties tab.
gt; Which properties tab?
gt; But by what you said after leads me to think you are trying to use microsoft
gt; query to refresh or updata a table or named range. if not, ignore this post.
gt; if your data is skued after refresh then i would guess that the table or
gt; named range is too small and does not cover all of your table data. Try
gt; resetting your table.
gt; high light your data then on the menu bar click
gt; insertgt;namegt;define.
gt; you may have to reset more than one table.
gt;
gt; regards
gt; FSt1
gt; quot;Rental Manquot; wrote:
gt;
gt; gt; I am using Excel 2003
gt; gt;
gt; gt; I have selected in the propertoes tab quot;insert entire rows for new data,
gt; gt; clear unused cellsquot;, yet when I refresh with changed data, the new data is
gt; gt; there but new rows are not being added. I have tried this numerous times
gt; gt; using a variety of the check boxes, including quot;fill down formulas in adjacent
gt; gt; columnsquot; to no avail.
gt; gt;
gt; gt; Here is what I am trying to do, in case there is a better way:
gt; gt;
gt; gt; I want to have a spreadsheet with 12 monthly worksheets and one YTD
gt; gt; worksheet. As I added new items to the inventory, I want to update each of
gt; gt; these worksheets to reflect the new items. Most of the time the new items
gt; gt; will be in between existing items.
gt; gt;
gt; gt; What I have done is prepared two spreadsheets, one with the monthly and YTD
gt; gt; workbooks and another with only the inventory listing. Refresh works
gt; gt; properly as far as adding the new item, but it is not adding a complete line
gt; gt; for the data, such that each new item quot;capturesquot; cells to the right of it
gt; gt; which is data for the item which is now beneath it, causing my last item to
gt; gt; be one row off for each new inventory added.
gt; gt;
gt; gt; I am also open to having all the data come from within one spreadsheet.
gt; gt;
gt; gt; Thanks in advance for any thoughts, ideas or suggestions!
gt; gt;
gt; gt; Rental Man