ryanangus496
New Member
- Joined
- May 5, 2021
- Messages
- 1
- Office Version
- 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!!
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!!