LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
MDW MDW is offline
external usenet poster
 
Posts: 117
Default Strange Link Appearing Automatically

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Strange letters appearing in Excel 97 Red_9 Excel Discussion (Misc queries) 0 August 26th 06 01:14 AM
values are appearing automatically in the next column psdonline Excel Discussion (Misc queries) 0 July 12th 06 10:40 PM
How to stop reviewing bar from automatically appearing ChAnDeRu Excel Discussion (Misc queries) 12 July 9th 05 02:13 PM
How to prevent "Reviewing" toolbar from "automatically" appearing? FishHead Excel Discussion (Misc queries) 1 March 30th 05 05:00 PM
toolbar automatically appearing Gus Excel Discussion (Misc queries) 1 January 24th 05 10:44 PM


All times are GMT +1. The time now is 01:12 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"