Previous Topic Next Topic

Excel linked to database

Closed
swanky - May 27, 2011 at 09:48 AM
rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - May 27, 2011 at 10:31 AM
Hello,

i m working on a excel sheet which is linked to database ,which means whenever i refresh it gets updated.i have created a new column in that sheet which gives me the the requirements to sort a defect.whenever status of a defect in the status column is closed ,the entire row gets deleted as it is programmed like that and the data in the cells moves up.but the data in new column is not getting updated along with that .so, is there a way how i could link that column to others and get it updated as i refresh.


1 reply

Answer 1 / 1
rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 767
May 27, 2011 at 10:31 AM
When you say "i refresh it". The "it" part refers to workbook or database ?
The you did not mention how this "new column" in the sheet gets populated in the first place. If the row get deleted, how come you need any refresh on the workbook as things are still same (minus the row that got deleted). I am thinking what it is doing is deleting the range and not the row. if that is the case you can change the process to delete the row or increase the range to include this new column
0