Is possible Save a Excel File without Formulas(only the Values)?

[jamiguel77]

Hi all, easy question.

Is possible Save a Excel File without Formulas(only the Values)?

My excel file have formulas same as:

=C24-'\\172.27.10.15\Box Documents\Default Sync Folder\[RDF.DEL 05 AL 11 DE MAYO.13.XLS]MAU'!$O$24

but my tablet not know it! the result of this formula is: -1068 and in my tablet i see#REF (i sync files with DropBox)

Thanks

[oeldere]

You see #ref while the other workbook isn't open.

you could use copy - paste special - values fo this part of your formula
'\\172.27.10.15\Box Documents\Default Sync Folder\[RDF.DEL 05 AL 11 DE MAYO.13.XLS]MAU'!$O$24

[nemo74]

You could make a copy of that file, select the cells with the formulas, copy and then past values. Save it and your tablet would not have an issue.

[jamiguel77]

NOTE: the file: RDF.DEL 05 AL 11 DE MAYO.13.XLS is in same place: of my file.
not understand why the formula was converted:

=C24-'\\172.27.10.15\Box Documents\Default Sync Folder\[RDF.DEL 05 AL 11 DE MAYO.13.XLS]MAU'!$O$24

in place of:

=C24-'[RDF.DEL 05 AL 11 DE MAYO.13.XLS]MAU'!$O$24

Really this my way/solution.


[oeldere and nemo74] Mmmm yes i see this option, that you mentioned .....

really not like me.

but if no option.....

Thanks Friends.