Break "Link" using Xlookup to Index Match workbooks

S

Soren

New Member
Joined
Apr 25, 2006
Messages
39
Office Version
  1. 365
Platform
  1. Windows
  2. MacOS
I have a summary spreadsheet (containing 30 tabs, representing individual departments ) "linked" to 12 individual monthly spreadsheets, with similar tab names as summary spreadsheet, all "linked" together using Xlookup and Index Match formula.
I there a way (other than copying some 31000 formula cells as values manually, excluding local formula in the summary spreadsheet) to break this relationship?
Obviously using Index Match does not create a breakable link in Excel.
regards

Soren
 

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.
You must log in or register to reply here.

Similar threads

P
  • Question
How to use a MATCH helper column containing rows from a different sheet and INDEX in an array formula to return based on data in the helper column?
Replies
0
Views
177
purekarting
P
E
  • Question
How to recognize text strings in INDEX-MATCH
Replies
5
Views
375
dfsobral
D
F
  • Question
Tie-Breaking Question (Using Index/Match/Large)
Replies
3
Views
343
Fluff
Fluff
E
  • Question
can't get INDEX-MATCH to copy entire column
Replies
2
Views
65
shift-del
shift-del
A
  • Question
Xlookup, Vlookup and/or VBA for finding, matching and inputting data to separate sheet
Replies
0
Views
532
AlfredDB
A

Forum statistics

Threads
1,215,119
Messages
6,123,172
Members
449,094
Latest member
bes000

Share this page

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
Back
Top