LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3
Default Replacing values in formulae with links

I need help with replacing values in formulae with links.

I inherited supporting several Excel workbooks with very involved formulae
involving links

For example:
=SUM(IF('\\ttemail\global\Operations\Forecasting\I nbound\[Inbound CC Stats
Call
Volumes.xls]C-Rcvd'!$F$4:$F$978=$B1,'\\ttemail\global\Operations \Forecasting\Inbound\[Inbound
CC Stats Call
Volumes.xls]C-Rcvd'!O$4:P$978,))+SUM(IF('\\ttemail\global\Operat ions\Forecasting\Inbound\[Inbound
CC Stats Call Volumes
Tucson.xls]C-Rcvd'!$F$4:$F$978=$B1,'\\ttemail\global\Operations \Forecasting\Inbound\[Inbound CC Stats Call Volumes Tucson.xls]C-Rcvd'!O$4:P$978))

and what I need to do is a global replace of all the instances of $978 with
$1343

The problem is that when I try to use Edit|Replace (Look in Formulas) the
process seems to get hung.

I assume that each time Excel changes the formula it then tries to update
the cells, and that it would therefore take much longer than necessary.

I even tried using C# and the Excel COM objects to do this programmatically,
but the same problem happened.

How can I accomplish this?
Is there a way to turn off updates as the replacements are being made?

 
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
Changing formulae links [email protected] Excel Programming 1 August 14th 06 07:21 PM
Macro replacing links [email protected] Excel Discussion (Misc queries) 1 August 10th 06 04:08 PM
Replacing Formulae With Values.....Continuation [email protected] Excel Programming 15 June 29th 05 09:58 AM
Another Question Concerning Replacing Formulae With Values ! [email protected] Excel Programming 15 June 29th 05 04:03 AM
Replacing links with values John[_68_] Excel Programming 1 December 15th 03 05:47 PM


All times are GMT +1. The time now is 11:40 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"