Dynamic Print Area - Name Formula being overwriten/resetting

ryanangus496

New Member
Joined
May 5, 2021
Messages
1
Office Version
  1. 365
Hi!!

I have an excel model with output sheets. In the output sheets I have a dynamic formula in the print area creating a dynamic print area. However, at some stage between versions of the files (and hours of work, not on the output tabs), a bug seems to have developed:
- The IF or SWITCH formula I use in the name manager to set the dynamic print area resets to whatever the print area selected from the formula is, meaning the dynamic print area is only good for one use before it resets to what was selected.

I.e. I have a detailed IF(xxxxxxxx ) formula and if that selects cells A1-B1 (just for example), in the name manager the print area is overwritten to A1-B1. I am totally stuck. I have tried resetting the formulas and everything, at this point I am stuck.

I looked back to the prior version of my file, and nothing is different in my settings etc.

Any help at this point, is GREATLY Appreciated! Thanks!!
 

Excel Facts

Links? Where??
If Excel says you have links but you can't find them, go to Formulas, Name Manager. Look for old links to dead workbooks & delete.

Forum statistics

Threads
1,147,476
Messages
5,741,349
Members
423,656
Latest member
Medrok2021

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top