I am attempting to link two large spreadsheets using formulas for each cell.
I want text, numbers, dates etc. to populate, but if a cell is blank, I want
a blank cell left in the cell.

I have always used =if([Wksht1]Input.xls!A1="","",[Wksht1]Input.xls!A1).
This seemed to work fine in Excel 2003. In Excel 2007 it works fine in the
sheet that the formula resides, but calculations based on the first sheet
return errors. The error is occurring because the calculation is not seeing
blanks, but "".

As an example: A second sheet has the formula in a cell
=(Input!$A1+(Input!$B1*Input!$C1/1000))

When I Evaluate the formula, I get =(""+(""*""/1000)), which returns #VALUE!.

I really do not want to go into the second 80 Meg (in Excel 2007), 400 Meg
(in Excel 2003) spreadsheet and add conditionals to all the formulas (40
Pages, at least 100 columns per page, 700 rows of data), to ignore the ""
entries, so the math works throughout the spreadsheet.

Is there a setting, or another way (without Macro's) that I can get a blank
cell out of a formula?

Thanks