Hello all,
my workbook is links to external Workbook Named Ramp Schedule Tool.xlsm and when Ramp Schedule Tool is not opened the status shows Error: worksheet not found. When I click on Update Values in the Select Sheet box shows the worksheet its looking for in the Ramp Schedule Tool Workbook is called Ramp schedule tool worksheet. However, non of for formulas references to a Worksheet named Ramp Schedule tool in that workbook. Not sure why its looking for that Worksheet name. My formula refers to other worksheets within Ramp Schedule tool Workbook. I actually do not have a Worksheet named the same as the Workbook name.
I know how to fix it by changing the Source and relocating the file, However, must of users do not know and Change Source it takes long time to update as it has many cells that reference the workbook. I was trying to find a permeant fix where its not needing to change source all the time .
I have done the following find for "[Ramp Schedule Tool.xlsm]Ramp" just to be sure that nothing is refer to such worksheet by accident and no results were found. any help is greatly appreciated
my workbook is links to external Workbook Named Ramp Schedule Tool.xlsm and when Ramp Schedule Tool is not opened the status shows Error: worksheet not found. When I click on Update Values in the Select Sheet box shows the worksheet its looking for in the Ramp Schedule Tool Workbook is called Ramp schedule tool worksheet. However, non of for formulas references to a Worksheet named Ramp Schedule tool in that workbook. Not sure why its looking for that Worksheet name. My formula refers to other worksheets within Ramp Schedule tool Workbook. I actually do not have a Worksheet named the same as the Workbook name.
I know how to fix it by changing the Source and relocating the file, However, must of users do not know and Change Source it takes long time to update as it has many cells that reference the workbook. I was trying to find a permeant fix where its not needing to change source all the time .
I have done the following find for "[Ramp Schedule Tool.xlsm]Ramp" just to be sure that nothing is refer to such worksheet by accident and no results were found. any help is greatly appreciated
