Posted 8 September 2017, 1:16 pm ESTWe use range names to load and save data at runtime. If I open a multi-sheet Excel file at runtime, I can see all the custom names in the entire file from each sheet. Is this the intended behavior?
Custom Names in a multi-sheet control
Posted by: judir on 8 September 2017, 1:16 pm EST
Replied 8 September 2017, 1:16 pm EST<P>Hello,</P>
<P>This is by design. In version 1, each sheet in a workbook was treated as a separate calculation unit (with each sheet having its own collection of custom names and its own collection of custom functions). We got some complaints because this behavior was different from the behavior found in Excel.</P>
<P>In version 2, we added an EnableCrossSheetReference property. When EnableCrossSheetReference = True, all sheets in a workbook work together as a single calculation unit (with all sheets sharing a single collection of custom names and a single collection of custom functions). This provides behavior that more closely matches Excel. When EnableCrossSheetRefernce = False, you get the behavior found in version 1. By default EnableCrossSheetRerence = True.</P>
Replied 8 September 2017, 1:16 pm EST<P>Thanks Scott, that makes perfect sense; just wanted to be sure that I could rely on seeing all custom names from any sheet.</P>