1 of 1 people found this helpful
Jonathan Drummey wrote this excelent post - Re: Are calculated fields stored in the datasources at all or always in the workbooks? about the calculated field topic. Check that thread out and see if it answers your questions.
I hope this helps,
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.