Saving an Excel file for Vensim to use

ajclarke · Post by **ajclarke** » Tue Oct 05, 2010 8:31 am

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?

Post by **Administrator** » Tue Oct 05, 2010 9:42 am

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

ajclarke · Post by **ajclarke** » Tue Oct 05, 2010 10:30 am

You're right ....

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