Why did my Excel Checkbook stopped totaling after 30 entries???

[Sylverkitti]

I downloaded the Excel checkbook template, and after 30 entries it stops
doing the total for me. I see it is shaded down to number 30, and I don't
know how to keep this going. Anyone have any ideas?

 

[Pete_UK]

If you can post the formulae that are used here, then we might be able
to help you - we don't all have that particular template.

Pete

 

[Gord Dibben]

A template creates a new workbook each time it is opened.

The original template does not get overwritten or contain data.

Why would you run out of rows in the template?

Whatever the case..................find the original template on your hard drive
and select then right-click and open.

This opens the actual template, not a new copy.

Select B89:H89 and drag/copy as far as you wish.

Use the format painter to format the banding.

Save the template (*.xlt)

If the cells above don't look familiar, please post the URL from where you
downloaded your Template.


Gord Dibben MS Excel MVP

 

[Sylverkitti]

Can you tell me how to get the formula? I don't know how to retrieve that.
Thanks

:
w to retrieve that

 

[Sylverkitti]

I am a total newb at excel....I can show you what I mean via screen shot....I
didn't run out of rows, theres a bunch there but 1-30 is shaded darker and I
payed no attention to that fact till I got to row 31, it no longer totaled
things for me, had to do it by myself.

 

[Gord Dibben]

Post the URL for the downloaded Template.


Gord

I am a total newb at excel....I can show you what I mean via screen shot....I
didn't run out of rows, theres a bunch there but 1-30 is shaded darker and I
payed no attention to that fact till I got to row 31, it no longer totaled
things for me, had to do it by myself.