Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]() I have workbook1 with formulas using named ranges in external workbook2. This worked fine until I accidentally deleted the named ranges in the external workbook. I put ranges back correctly and now formulas will not work unless external workbook2 is open at the same time as workbook1. Anyone have any ideas. Really irritating. Any advice is appreciated. Thanks a lot JKC -- JKC ------------------------------------------------------------------------ JKC's Profile: http://www.excelforum.com/member.php...o&userid=31166 View this thread: http://www.excelforum.com/showthread...hreadid=519803 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Import external data problem | Excel Discussion (Misc queries) | |||
Using a named range in a header with VBA? | Excel Discussion (Misc queries) | |||
Can I use named range in data range box when creating pie chart? | Charts and Charting in Excel | |||
dynamic named range function | Excel Worksheet Functions | |||
Match function...random search? | Excel Worksheet Functions |