Do you mean can it be done without a formula? - No
Or do you mean will the formula work automatically? - Yes
In B1 of FileA: =A1+[FileB.xls]Sheet1!A1
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email
"Welthey" <(E-Mail Removed)> wrote in message
news:2D5C0CF9-66DA-4A1C-A7E6-(E-Mail Removed)...
>I currently have 2 spreadsheets. I need to have a value from Spreadsheet B
> automatically add into the value on Spreadsheet A. Is there an easy way
> to
> do this without someone have to put in the + into the formula bar?