Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Inserting a new line in spreadsheet
I am using Excel 2003
I have selected in the propertoes tab "insert entire rows for new data, clear unused cells", 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 "fill down formulas in adjacent columns" 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 "captures" 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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Inserting a new line in spreadsheet
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 insertnamedefine. you may have to reset more than one table. regards FSt1 "Rental Man" wrote: I am using Excel 2003 I have selected in the propertoes tab "insert entire rows for new data, clear unused cells", 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 "fill down formulas in adjacent columns" 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 "captures" 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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Inserting a new line in spreadsheet
I am accessing the external data as follows:
Data -- Import external data -- import data -- new source -- ODBC SAN -- excel files -- excel file name -- select a table from the list, such as NAMES (connect to spefici table is checked) -- name the external link -- click finish -- import data box pops up -- select properties button on the bottom -- select "insert entire rows for new data, clear unused cells" and "fill down formulas in adjacent rows" 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 "orphaned" 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. "FSt1" wrote: 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 insertnamedefine. you may have to reset more than one table. regards FSt1 "Rental Man" wrote: I am using Excel 2003 I have selected in the propertoes tab "insert entire rows for new data, clear unused cells", 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 "fill down formulas in adjacent columns" 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 "captures" 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to add a vertical line to a Line Chart that aleady has 2 Y axi | Charts and Charting in Excel | |||
strange horizontal line showing accross several columns | Excel Discussion (Misc queries) | |||
Label an average line in a dynamic chart | Charts and Charting in Excel | |||
How do I reverse a spreadsheet that is in the format of a subtota. | Excel Discussion (Misc queries) | |||
pivot table multi line chart | Charts and Charting in Excel |