my excel spread sheets no longer adds new data entered in ranges. I use
Excel to track construction expenses. Recently the workbook spreadsheets
stoped adding new data entered into the ranges.
my excel spread sheets no longer adds new data entered in ranges. I use
Excel to track construction expenses. Recently the workbook spreadsheets
stoped adding new data entered into the ranges.
Tools>Options>Calculation is set to "Manual"?
The SUM range is too narrow and does not include the new data rows/columns?
Gord Dibben Excel MVP
On Mon, 7 Nov 2005 14:05:04 -0800, "Art-needs-help"
<[email protected]> wrote:
>my excel spread sheets no longer adds new data entered in ranges. I use
>Excel to track construction expenses. Recently the workbook spreadsheets
>stoped adding new data entered into the ranges.
Gord thanks very much. I don't know how the manual option got clicked but
that was the problem. I fiddled around checking formulas and reentering data
for a couple hours before I gave up and posted the question. So your very
correct and very quick responce is greately appreciated. Many Thanks.
"Gord Dibben" wrote:
> Tools>Options>Calculation is set to "Manual"?
>
> The SUM range is too narrow and does not include the new data rows/columns?
>
>
> Gord Dibben Excel MVP
>
> On Mon, 7 Nov 2005 14:05:04 -0800, "Art-needs-help"
> <[email protected]> wrote:
>
> >my excel spread sheets no longer adds new data entered in ranges. I use
> >Excel to track construction expenses. Recently the workbook spreadsheets
> >stoped adding new data entered into the ranges.
>
>
Thanks again Gord! Just in case my first thank you didn't find it's way to you.
"Art-needs-help" wrote:
> my excel spread sheets no longer adds new data entered in ranges. I use
> Excel to track construction expenses. Recently the workbook spreadsheets
> stoped adding new data entered into the ranges.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks