clear data from workbook

G

Guest

We do bids in Excel - the last bid contains all the formulas, recaps that we
need. How do I clear all the data from this workbook without losing the
formulas?

Also I keep getting#value for a total column that is correct - sums are
checked and rechecked and it still won't work
 
G

Guest

Do you enter your data into the formulas?
or do you enter the data in cells which are used in the formulas?
If you enter the data directly in the formula you might want to change the
formulas so that they do reference cells you can erase

for the second problem, what is the exact formula?
you can only have up to 30 ranges listed in the sum() function

if you can use a helper coulmn next to the data being summed. in each cell
enter =sum(just one cell) you should be able to find the cell with the error
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Creating a list in sequential order 6
Pulling data from another workbook 2
how to clear data 3
Lookup changing data range in external workbook 5
Using SUM & VLOOKUP together?? 1
How do I clear data values wthout losing the formulas? 1
can we count words in a row which has links from other file 2
Creating a duplicate workbook without values 2

Top