Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Auto Open
Hello Everybody,
I have Excel 2003 on WinXP SP2. I have copied a worksheet, "Invoice", into my Excel file called "Databased". Although, I have broken all links in the worksheet but still it tries to open the original file from where I copied the it. If the file is not found I get following error when "Databased" is opened: Cannot find 'C:\[ILYASBILLING Template (uw).xls]AutoOpen Stub Data'!, which has been assigned to run each time [Databased.xls]Invoice is opened. Continuing could cause errors. Cancel opening [Databased.xls]Invoice? Now I have no idea how to search and destroy this "AutoOpen Stub Data" because I already have deleted all previous formulas and links to other files that I knew. Can anybody help in this case? Thank you, -- Syed Zeeshan Haider ------------------------------------------------------------------------------------------------------- Download a free game to play with Internet Explorer from http://szh.20m.com/entertainment/olwg.html |
#2
|
|||
|
|||
Hi,
Try copying all the contents to a new file (not new worksheet) and then edit the formulae to get rid of the links to the old file. Finally, copy all VBA code (if any) to the new document. Regards, Peter -- http://blog.jausovec.net "Syed Zeeshan Haider" je napisal: Hello Everybody, I have Excel 2003 on WinXP SP2. I have copied a worksheet, "Invoice", into my Excel file called "Databased". Although, I have broken all links in the worksheet but still it tries to open the original file from where I copied the it. If the file is not found I get following error when "Databased" is opened: Cannot find 'C:\[ILYASBILLING Template (uw).xls]AutoOpen Stub Data'!, which has been assigned to run each time [Databased.xls]Invoice is opened. Continuing could cause errors. Cancel opening [Databased.xls]Invoice? Now I have no idea how to search and destroy this "AutoOpen Stub Data" because I already have deleted all previous formulas and links to other files that I knew. Can anybody help in this case? Thank you, -- Syed Zeeshan Haider ------------------------------------------------------------------------------------------------------- Download a free game to play with Internet Explorer from http://szh.20m.com/entertainment/olwg.html |
#3
|
|||
|
|||
Already tried it but the original worksheet is too complex to be copied.
"Peter Jausovec" wrote in message ... Hi, Try copying all the contents to a new file (not new worksheet) and then edit the formulae to get rid of the links to the old file. Finally, copy all VBA code (if any) to the new document. Regards, Peter -- http://blog.jausovec.net "Syed Zeeshan Haider" je napisal: Hello Everybody, I have Excel 2003 on WinXP SP2. I have copied a worksheet, "Invoice", into my Excel file called "Databased". Although, I have broken all links in the worksheet but still it tries to open the original file from where I copied the it. If the file is not found I get following error when "Databased" is opened: Cannot find 'C:\[ILYASBILLING Template (uw).xls]AutoOpen Stub Data'!, which has been assigned to run each time [Databased.xls]Invoice is opened. Continuing could cause errors. Cancel opening [Databased.xls]Invoice? Now I have no idea how to search and destroy this "AutoOpen Stub Data" because I already have deleted all previous formulas and links to other files that I knew. Can anybody help in this case? Thank you, -- Syed Zeeshan Haider ------------------------------------------------------------------------------------------------------- Download a free game to play with Internet Explorer from http://szh.20m.com/entertainment/olwg.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
When I open excel document it always ask if I want to open it in . | Excel Discussion (Misc queries) | |||
message/dialog box auto open when excel file is activated | Excel Discussion (Misc queries) | |||
How do I set Excel to auto open a document into a new Window even. | Excel Worksheet Functions | |||
Cannot open a file that Excel says is open | Excel Discussion (Misc queries) | |||
auto update an open excel sheet over network, with mutiple users | Excel Worksheet Functions |