Ventana software support forum

I have an Excel file ( actually an xlsx ) that has several tabs and formulae.

To be used by Vensim I save it as an xls BUT also have to copy/paste special each Tab to be Values not Formulae.

Is there a simple way of telling Excel to save the whole worksheet as Values?

You shouldn't need to save all as values. What is the problem, are you linking via XLS or importing the Excel files?

You're right ....

The problem was blank cells ( e.g. meant to be zero )