Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2
Default replace always opens a window

When I want to replace a number in a formula it always opens a window asking
me to choose a file. How do I prevent this and just have it replace the
numbers?

  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 3,355
Default replace always opens a window

Does your formula reference another workbook? If so, it's probably not a
real link anymore.
--
HTH,
Barb Reinhardt



"Meinarsson" wrote:

When I want to replace a number in a formula it always opens a window asking
me to choose a file. How do I prevent this and just have it replace the
numbers?

Reply
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
Office XP: Excel only opens in one window. OfficeXPUser Excel Discussion (Misc queries) 5 October 13th 08 04:17 AM
Template opens in hidden window? ktlasers Excel Discussion (Misc queries) 0 October 4th 07 09:30 PM
The window opens in a smaller window not full sized window. Rachael Excel Discussion (Misc queries) 0 November 7th 06 09:04 PM
Excel opens all workbooks within the same app window. rana Excel Discussion (Misc queries) 2 January 27th 06 09:20 AM
Help window opens minimized Dick L Excel Discussion (Misc queries) 0 September 22nd 05 12:07 AM


All times are GMT +1. The time now is 05:14 PM.

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

About Us

"It's about Microsoft Excel"