Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Remove previous file reference
Hi, I currently am working on editing a template on of my coworkers had edited and needed some changes to. Unfortunately, the spreadsheet is automatically prompting for a file that it no longer uses. There is no reference to it within the file itself, meaning I believe it it looking for previous code or something. The current file has no use for this referenced file though, so I need to get rid of it so it stops prompting the user to find the useless file. Any ideas? -- mkerstei ------------------------------------------------------------------------ mkerstei's Profile: http://www.excelforum.com/member.php...o&userid=25688 View this thread: http://www.excelforum.com/showthread...hreadid=549048 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Remove previous file reference
Hi mkerstei,
Does the old file still show up if you use Edit|Links? If so, you still have a reference to it. The reference could be in a formula (most likely), a defined name or a macro. You cab use Edit|Find to search each worksheet for the filename in a formula, Insert|Name to look for it in a defined name or Alt-F8 to see if there's a macro with a reference to it. Cheers -- macropod [MVP - Microsoft Word] "mkerstei" wrote in message ... Hi, I currently am working on editing a template on of my coworkers had edited and needed some changes to. Unfortunately, the spreadsheet is automatically prompting for a file that it no longer uses. There is no reference to it within the file itself, meaning I believe it it looking for previous code or something. The current file has no use for this referenced file though, so I need to get rid of it so it stops prompting the user to find the useless file. Any ideas? -- mkerstei ------------------------------------------------------------------------ mkerstei's Profile: http://www.excelforum.com/member.php...o&userid=25688 View this thread: http://www.excelforum.com/showthread...hreadid=549048 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Remove previous file reference
You got it...it was a named range. i can't believe I missed that. Thanks for your help. -- mkerstei ------------------------------------------------------------------------ mkerstei's Profile: http://www.excelforum.com/member.php...o&userid=25688 View this thread: http://www.excelforum.com/showthread...hreadid=549048 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Remove previous file reference
You got it...it was a named range. i can't believe I missed that. Thanks for your help. -- mkerstei ------------------------------------------------------------------------ mkerstei's Profile: http://www.excelforum.com/member.php...o&userid=25688 View this thread: http://www.excelforum.com/showthread...hreadid=549048 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do i remove READ ONLY setting on a file? | Excel Discussion (Misc queries) | |||
File reference | Excel Worksheet Functions | |||
Weird File Open/Save As Behavior | Excel Discussion (Misc queries) | |||
Remove or change password protected excel file | Excel Discussion (Misc queries) | |||
Making a file and worksheet reference into a variable.... | Excel Worksheet Functions |