Edit links to different worksheet within workbook

Mandi

New Member
Joined
Feb 20, 2009
Messages
20
Hi Guys, I've not posted for a couple of years but have a tricky one now. I have searched and can't really find my exact problem.
I have 94 workbooks designed as holiday forms, each sheet is a month and the rows are the days of the month with columns being for holidays taken or extra hours worked.
These all link to a master spreadsheet in another workbook.
I have manually created all the links for April, and wanted to copy the links into a blank sheet, find and replace april with May then paste back into the master spreadsheet, to save me having to recreate all the links everymonth.
Find and replace doesn't work with links, I tried Edit Links but it wants me to select a different workbook whereas I only want to go to a different worksheet within the same book.
Can anyone help?
 

Excel Facts

Excel Can Read to You
Customize Quick Access Toolbar. From All Commands, add Speak Cells or Speak Cells on Enter to QAT. Select cells. Press Speak Cells.

GlennUK

Well-known Member
Joined
Jul 8, 2002
Messages
11,689
Find and replace does work with links! Give an example of a link formula that you were trying to do that on.
 

Mandi

New Member
Joined
Feb 20, 2009
Messages
20
='\\Fileserver\msbil\Management Holidays\Management Holidays NEW FORMAT\2011-2012\[John Smith.xls]April'!$E$5

I've tried it in the same worksheet and in a different one, Glenn...it says it can't find any data to replace and is the worksheet protected which it isn't.

Options I am using for Find and Repleace are

Within: Sheet
Search: by Rows
Look in:Formulas (there is not other option but this)
Thanks
 

GlennUK

Well-known Member
Joined
Jul 8, 2002
Messages
11,689
And you were trying to replace "April" with "May", is that it?
 
Last edited:

Mandi

New Member
Joined
Feb 20, 2009
Messages
20

ADVERTISEMENT

Yes Glenn, thats it..am I being really thick??? lol


:confused:
 

GlennUK

Well-known Member
Joined
Jul 8, 2002
Messages
11,689
No ... can't see what wrong with that. Am off now ... maybe someone else can spot it.
 

Mandi

New Member
Joined
Feb 20, 2009
Messages
20
Thanks Glenn, it now seems to work within the spreadsheet, rather than copying and pasting into a blank one. Sorry if I wasted your time...but thanks again
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,164,305
Messages
5,836,534
Members
430,437
Latest member
Emilycr

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top