Home |
Search |
Today's Posts |
#1
|
|||
|
|||
clear data from workbook
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 |
#2
|
|||
|
|||
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 "lynn" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Importing unopened worksheet into an open Workbook | Excel Discussion (Misc queries) | |||
Too much data to save a workbook | New Users to Excel | |||
linking workbook data | Excel Worksheet Functions | |||
macro to browse for workbook, pick up data and looping | Excel Worksheet Functions | |||
Help with data not getting plotted | Charts and Charting in Excel |