Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
My department uses an Excel workbook with macro-driven calculation and
modeling. The file is called Model.xls. The model has links to two external input files, also Excel workbooks. After the model is done calculating, it creates an output file by saving itself as output_Model.xls and then copying each worksheet and pasting the values. This process has been in place for years and we haven't experienced any problems with it. What we've discovered is that this output file has a link listed under the "Edit - Links" menu. Strangely enough the link isn't to either of the input files, but rather to the file "Model.xls". I can't locate any cells that actually reference this link - as I said, the final step in the creation of the output file is to copy/paste values on each sheet. Does anyone know how that link could have gotten there? It appears to be on every output file I can locate. It seems completely benign, but I'm just curious as to what process would have caused it to happen in the first place. As a bonus, if anyone has any suggestions for how we can prevent it from happening, that would be great as well. -- Hmm...they have the Internet on COMPUTERS now! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Strange letters appearing in Excel 97 | Excel Discussion (Misc queries) | |||
values are appearing automatically in the next column | Excel Discussion (Misc queries) | |||
How to stop reviewing bar from automatically appearing | Excel Discussion (Misc queries) | |||
How to prevent "Reviewing" toolbar from "automatically" appearing? | Excel Discussion (Misc queries) | |||
toolbar automatically appearing | Excel Discussion (Misc queries) |