LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #2   Report Post  
Posted to microsoft.public.excel.misc
bpeltzer
 
Posts: n/a
Default File anme change

If your memory permits, I'd open all eight files together. Then, switch to
each file in turn and File Save As and specify the new name. (Be sure to
SAVE AS, and NOT save!) Only after all eight files have been saved with
their new names, start closing the files, answering YES when asked if you
want to save changes.
(If the files are too big that you can't open them all at once, make the
copies. Then open one of the new files, and use Edit Links in the new
files; select a file it's linked to and click Change Source. Repeat for
each file it's linked to. Save and Close. Repeat for the next new file.)
--Bruce

"Gordon" wrote:

Hi

I have 8 files all with direct links to each other they are called cg1 cg2
etc. I need to change the file names to v1, v2 etc but think this will
corrupt cell references to external lonks. Can I do this with a little pain
as possible? I don't want to renter 5000 odd formulas all over again...

Thanks in advance G

 
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
How to change a MS Word file to an Excel file Sameera Excel Worksheet Functions 1 June 28th 05 08:57 PM
How do I change file/open/"files of type" to default to "all file. How do I changefiles of type default Excel Discussion (Misc queries) 1 April 19th 05 10:45 PM
how a file can change its type from '.xls' to '.tmp' puzzled Excel Discussion (Misc queries) 2 February 18th 05 10:54 PM
Read Text File into Excel Using VBA Willie T Excel Discussion (Misc queries) 13 January 8th 05 12:37 AM
How do I change how a file is inserted into outlook? km6090 Excel Discussion (Misc queries) 1 December 12th 04 10:17 PM


All times are GMT +1. The time now is 11:09 PM.

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"