| Home |
| Search |
| Today's Posts |
|
#10
Posted to microsoft.public.excel.misc
|
|||
|
|||
Links no longer work
Thanks alot guys!!!
"Dave Peterson" wrote in message ... Those things that Gord mentioned have fixed it for lots and lots of people. I'd try them again. ps. I haven't used it in xl2007 enough to know that it works there, too. But it's been recommended to lots of xl2007 users and not many have complained that it didn't fix the problem there. I'd try it again. Scott D wrote: When I use ctrl-o the link works fine, so it must be multiple instances. I just can't figure out why it changed by itself. Is there a preference somewhere that would force single instances all of the time? "Dave Peterson" wrote in message ... It sounds like you did it ok to me. Does "no fix" mean that you were still running two instances of excel or that you couldn't get the link to work correctly. If you close excel (all instances), then open the first workbook, then use ctrl-o to open the second, does the copy|paste link work ok? If yes, then the problem is the multiple instances. I don't use xl2007 enough to know for sure, but I'd do those steps that Gord wrote. If the link doesn't work in that single instance, then you'll have to share more info--what are the exact steps you're doing and where does it break down? Scott D wrote: Gord, I did what you said. Let me make sure I did it right. First, I'm using 2007 so I assume ToolsOptionsGeneral Uncheck "Ignore Other Applications" is for 2003. Instead I went to the office buttonadvancedgeneralUncheck "Ignore other applications that use Dynamic Data Exchange (DDE)" It was already unchecked in my application. I then followed your instructions using the run command. I did it two ways. The first way I did it was just as you wrote...after the first command executed and opened a fresh instance of excel, I immedately ran the second comand which opened another fresh instance of excel. I closed both and checked my files...no fix. The second way was to run the first command, close excel then run the second command and close that instance of excel. Checked my files...no fix. Did I do it right? "Gord Dibben" <gorddibbATshawDOTca wrote in message ... See my post for fixes. Gord On Tue, 2 Jun 2009 12:56:11 -0500, "Scott D" wrote: OK, I think I had two instances running but I've never had this problem before. Let me explain further... I have a shortcut to two separate workbooks on my desktop ("checkbook" and "currently"). I've always opened both files from these shortcuts. Today, when I opened each workbook, I guess they each opened in a different instance of excel...I don't think I've changed anything to cause this. Each month I add a worksheet to the "checkbook" workbook and then switch to the "currently" workbook via the taskbar. I then select the destination cell, hit the equal sign, switch back to my new page in the "checkbook" workbook via the task manager, select the source cell and hit enter. Today it wouldn't recognize the other workbook. The way I got it to work was to open the first workbook and then open the second workbook from the recent documents list from the office/excel button in the first workbook. Why the change all of a sudden? The only thing peculiar that I can think of is that along with a lot of people (according to the web) I've had issues with the DDE after updating windows to sp3. I've had to insert "%1" in the action part of the file type xlsx, xls and xlsm to allow them to open from a click on the shortcut located on my desktop, but that was months ago, not today. Any thoughts...sorry if this post bounces around. "Dave Peterson" wrote in message ... Does this mean that existing links no longer update? Or that you can't create a new link by Copy|paste special|paste link? If it's the first, if you select the cell with the formula, and hit F2, then enter, does the cell re-evaluate? If it's the second, make sure both workbooks are open in the same instance of excel. Scott D wrote: All of a sudden I can't get a cell to link to another workbook in excel 2007. This has never happened before. It is as if the workbooks are not seeing each other. not working with existing or new workbooks. -- Dave Peterson -- Dave Peterson -- Dave Peterson |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Why do my drop down filters no longer work? | Excel Discussion (Misc queries) | |||
| How do I get the Fitness Chart for Men to work longer? | New Users to Excel | |||
| My links no longer work . . . | Excel Discussion (Misc queries) | |||
| Arrow Keys no Longer Work | Excel Discussion (Misc queries) | |||
| Keyboard shortcuts no longer work | Excel Discussion (Misc queries) | |||
Threaded Mode
