0

Only calculate some sheets

Cat

October 22, 2018 08:13

None

Follow

Hi,

I have an Excel file with several sheets. One option sheet and each other sheet stands for one report.

On the option sheet I want to control which sheets should be calculated.

I always do the reports for more than one company. At the moment I fill the company filter with an invalid company name for the sheets which shouldn't be calculated. It works but always with an error message for that sheets.

Is there any better way you can think of?

Thanks in advance,

cat

• Facebook
• Twitter
• LinkedIn

3 comments

• 0
  
  Harry Lewis October 22, 2018 14:13

  Hello Cat -

  When Excel calculates the functions and formulas within a workbook, it does so for all of the sheets within that workbook.

   

• 0
  
  Cat November 02, 2018 08:51

  Hello Harry,

  I know. :-|

  But I thougt/hoped maybe anyone knows a workaround without getting an error message. Something I havn't thought about at the moment.

• 0
  
  Andrew Cooper November 27, 2018 12:10

  Hi

  Am thinking that really you would have edit any formulas with an IFERROR function or, an if function based on a cell which might error.

  Andrew