Skip to main content

On-Screen Takeoff - 14.02 Price A Bid Using Microsoft Excel - OST


You can link your On-Screen Takeoff Condition Results to a Microsoft Excel™ workbook. Each Condition's result is linked to a specific cell (or named range) in Excel.


Refreshing Quantities

To refresh the Excel spreadsheet (meaning to push Quantity Results from On-Screen Takeoff to Excel) press <F9> or click Bid > Refresh Worksheet. By default, any time you leave a Bid linked to Excel or close the program, you are prompted to refresh the Excel spreadsheet. To disable this prompt, click Tools > Options and remove the check mark for "Prompt to refresh worksheet before closing Bid".

If you just want to copy and paste Takeoff Tab or Worksheet Tab data and paste it into Excel, see Related Articles.

The first step is selecting the Excel Workbook to which you want this bid linked.

click here to view the previous article Creating a Rough Cost Estimate on the Worksheet Tab Price Using Excel - Selecting the Workbook click here to view the next article

Related Articles

Did this topic help you find an answer to your question?

Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings