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...

Some videos you may like

This Week's Hot Topics

  • VBA (Userform)
    Hi All, I just would like to know why my code isn't working. Here is my VBA code: [CODE=vba]Private Sub OKButton_Click() Dim i As Integer...
  • List box that changes fill color
    Hello, I have gone through so many pages trying to figure this out. I have a 2020 calendar that depending on the day needs to have a certain...
  • Remove duplicates and retain one. Cross-linked cases
    Hi all I ran out of google keywords to use and still couldn't find a reference how to achieve the results of a single count. It would be great if...
  • VBA Copy and Paste With Duplicates
    Hello All, I'm in need of some input. My VBA skills are sub-par at best. I've assembled this code from basic research and it works but is...
  • Macro
    is it possible for a macro to run if the active cell value is different to the value above it
  • IF DATE and TIME
    I currently use this to check if date has passed but i also need to set a time on it too. Is it possible? [CODE=vba]=IF(B:B>TODAY(),"Not...