unlink

  1. K

    Remove ODBC links to Sage SQL Server

    I have a large spreadsheet (~100 tabs) that gets data from an SQL server using SQL queries. I am about to run a Year-End on Sage (for the first time) and am concerned that this will screw-up the data in the spreadsheet. I know that I can open each Tab in turn & unlink, or Copy/Paste...
  2. S

    Paste Chart Word, PPT, as a CHART, UN-link data

    Hello all! Long time lover of Mike and Bill.. Okay.. I would like to paste a pivot table chart into Word (or PPT), BUT maintain the benefits of chart functionality AND not have the chart update each time I adjust the pivot table. FYI, I've already seen the trick here...
  3. C

    Word merge keeps old fields

    Howdy, Excel world. Here's one I haven't even seen before. I have a program that opens a Word doc, links it to a worksheet and merges. So far, kindergarten stuff. Since I have a number of different types of docs I produce daily, each with its own set of data fields, the page I link to is...
  4. T

    Unlink Formula - slow calculation

    Hi All, Let's say I have 2 xls file (test1.xls & test2.xls); and test1 file referring the value from test2 file TEST 1.xls Cell (A1) => "Test" Cell (A2) => formula: =HLOOKUP(A1,'c:\[test2.xls]sheet1'!$H$2:$CF$125,124,FALSE) Cell (B1) => "Blah" Cell (B2) => formula...
  5. G

    VBA to copy Pivot Charts and paste in Word for each page field

    I have a worksheet with four pivot charts, all with the same page field (with 99 values). I would like to copy all 99 versions of all four charts and paste them in Word as embedded objects with links broken. Is this possible?
  6. W

    Formulas/VBA: .Replace after .Copy also edits source formulas

    Hi. My problem concerns copying and pasting formulas using VBA, then using .Replace to edit the formula in the destination cells. The problem I have is that the .Replace also changes the formula in the source cells. I want only the formulas in the destination cells to be edited. The code below...

Watch MrExcel Video

This Week's Hot Topics

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