Can you give us an example of such a formula? The exclamation point symbol,
!, is used to signify that the preceding is a sheet name. For instance, say
you want to reference a cell address, say A1. If the A1 you mean is on the
same sheet as the formula then you can say A1. But if the A1 is on another
sheet, say "MySheet", you would say MySheet!A1. If the sheet name has
spaces in it, like My Sheet, then you would say 'My Sheet'!A1. HTH Otto