I've got a cell that contains a number, and it is likely for hat number to increment or decrement itself on a ragular basis.

Could someone briefly explain how it would be made for the number to adjust automatically? For example, lets say that that cell is driven by a database, if I import data from a database, and then the information in the db changes, will Excel adjust accordingly? Please help -- I'm really stuck on this. It's part of some coursework I'm doing and I'm desperate for an answer.

If you really import the cell from a database, the value will change when you perform the import. then, it will not be changed until the next import.
If the cell is linked to a query to the database, it will probably change each time you refresh your view or each time you click in the "recalculate now" tag which is hidden somewhere in the Exclel menus.

How to increment the cell values when I linked two excel files
MS Excel -- Automatic Update Of Data

I am using two excel sheets. Sheet1 linked to sheet2.
For ex:
Sheet1's B1 cell linked to sheet1's c1;
Sheet1's B2 cell linked to sheet1's c2;
Sheet1's B3 cell linked to sheet1's c3

When I tried to link the first b1 cell and try to drag to copy on the same way the formulae for b2 and b3 cells., I am not getting the appropriate values. I am getting the same b1 cell values in the cell. I need to get the increment of cell number when I am dragging the cell value to the other cell values.

Can some one help me to solve this issue. It will save lots of my time.




-question by Madhu