To make sure I understand...there is a calculation on the view, but when you export it to Excel, you do not want it to appear? If this is the case, my best solution would be to place the calculation on a separate sheet and place the two worksheets on a dashboard together. Then, only export the sheet without the calculation.
Hope this helps!
Thanks for answering. I use the calculation in a tooltip to show the percentage change from the previous year. Having the calculation in another sheet will not work. Can you think of anything else which might help?