Referencing another sheet results in #VALUEs

[zachdwyer]

Formulas like this:

Result in PDFs like this:

I made sure that the externally referenced sheet was open while doing this, since Excel won't reference the sheet correctly unless it's open.

Maybe this has to do with OfficeToPDF starting a new session of Excel separate from the one I have open with the external sheet? If so, is there a way to open a "prerequisite" file before going through with the conversion process?

[vittala]

Hi -

Unfortunately we don't have a mechanism to force another workbook to open before opening the document to convert.

Regards Vittal