Break The Link Or Change The Source
Jan 18, 2007
I've recently aquired a spreadsheet previously maintained by someone else. After my initial review the speradsheet has many links that need to be updated, which I do via Edit-Links, but there are also some links that no longer need to exist. I have reviewed all sheets and some links just no longer exist, however when I try to break the link or change the source nothing happens. I have had the original owner also check and confirm and they have the same issue. Finally I tried copying all the tabs into a new workbook, but the link shows up again.
View 3 Replies
ADVERTISEMENT
Apr 18, 2008
I have a periodic task which involves moving some sheets from an existing workbook and presenting it in a new workbook. There are some diagram that I move as well from the worksheet. However, I also move the source data for the diagrams into the new workbook as well. Everytime I do this I need to change the source data to the new worksheet which is quite tiresome. Is there a smart hack to actually point the diagram source data to the new workbook?
View 2 Replies
View Related
Dec 13, 2013
I have created a PPT which is linked with my excel data and charts. Now I have to copy it at different location (Both PPT and excel), But due to change in path; my PPT is not updating with latest data points and charts. I know, I can change link using edit link.
My PPT is having around 50+ link. some VBA code which can replace old path using the current path.
View 1 Replies
View Related
Jan 18, 2012
I have to prepare a monthly presentation for my company. I have all financial data in multiple tabs in excel that have been linked to many powerpoint slides.
The problem is, I update the same excel sheet every month and save it with a different name. How can I change the source in powerpoint to select and update all the slides with all the corresponding tabs.
At present, I use Edit link (ALT+E+K) > Select each slide on the powerpoint> Change source to new excelfile. When I select all the sheets, the "change source" greys out. Hence I have to do it individually.
View 2 Replies
View Related
Apr 28, 2014
I copied a worksheet with a pivot table as a new worksheet. I wanted to group each pivot table differently on each worksheet, but the changes I make on one worksheet is reflected on the other. Is there a way to break the "link" between these tables?
View 2 Replies
View Related
Apr 14, 2011
if it's possible to break the connection between a pivot table and the data source whilst still maintaining the data in the table? I could try copy/paste special/paste values but thought there migth be a 'proper' way to preserve the data.
View 8 Replies
View Related
May 21, 2013
I'im using an index - match - match formula with links to an external file.
Everything works fine until I close the source workbook. At that moment the liks break. The error I'm getting is #REF!.
I suspect the reason is that the source data are in form of an official table. I tried some formulas with data in the same workbook but outside the table and they keep working after the source file is closed.
I really want to keep the source data in a form of an official excel table.
View 6 Replies
View Related
Aug 14, 2007
I inherited a spreadsheet that contains a link to another spreadsheet. I want to remove the link and I can not find a way to do this. I have checked under Edit/Links but there is not a delete or break links options. The linked spreadsheet does not exist.
View 4 Replies
View Related
Aug 7, 2014
This is the code I use to start a bash session and run a .sh:
[Code]....
It works well but it is a long-running program and I would like to close down Excel, or run different sessions of Excel, while it is running. Right now, if I close Excel while the bash is running, the external script stops.
Is there a modification to this command line that would safely sever the link between Excel and the bash session?
View 1 Replies
View Related
Jun 5, 2013
I have simple Countif and Averageif formulas that I would like to have linked to variable data in cell E6 on the Assumptions (2) tab however, the formula is not taking the cell as the criteria and only taking a hard number when I am using >=.
The example would be: I3 needs to be able to use the data changed in E6 for the >= number instead of the hardkey 29...
View 2 Replies
View Related
Jul 1, 2013
I have a formula in a cell which is refered to other cell within the same sheet and also to other sheet from other file. say
C1 = A1+B1+data file c1 Data file is another file in other location.
I was trying to break a external reference link (from Data File) from Data _ Edit Link, but it is converting all the formula to value. How is it possible to break only the external link without damaging the formula within the sheet say c1 = A1+B1+26 (value from data file c1)
View 5 Replies
View Related
Apr 1, 2009
Not sure if this can be done, still a rookie at this stuff. Everything works but can something be wrote into code too change list source?
View 5 Replies
View Related
Feb 8, 2006
I have created some link formula,
Example
CellA1 has ='Corridor Select- Input'!C5.
I was told by a colleague that there is a function in excel that allows me
to auto go to that linkd source. ie if I double click on Cell A1, I can
automatically go to Sheet"CorridorSelect-Input" Cell C5.
View 9 Replies
View Related
Jun 6, 2013
I have a spreadsheet in which I have several sheets, each of which has its own table populated by an SQL query that displays the data per sheet by customer name and then sorts by a status column that is either "open" or "closed" (Open in Descending order) and then sorts by created time (also in descending order). This table is 17 columns wide. Right next to this table, I have another 2 column table that is to be populated by hand. The problem is that the 2 tables don't talk to each other. For example:
If row 3 of table 1 contains an open action, then row 3 of table 2 will contain data pertaining to that action. If the action is closed via the database refresh, then it may move the action to row 10 now (as open is always shown at top) - however the data that was entered by hand in table 2 is still stuck in row 3.
find a way to make the 2 tables communicate and work together?
I cannot make it only 1 table as far as I can tell because the database refresh wipes out my additional manual columns every time.
View 1 Replies
View Related
Nov 21, 2006
For example, if my graph currently shows B1:L1 range, how by clicking a spin button to make the graph show B2:L2 range?
...
View 9 Replies
View Related
Sep 22, 2007
I would like to copy cells from one worksheet to another, but have the cells that I paste link to the original document. Is there an easy way to do this?
So if I'm pasting from worksheet A into worksheet B, I would like worksheet B to link to worksheet A.
View 9 Replies
View Related
Mar 4, 2008
I would like to put a page break everytime a column value changes. Example:
A
Atlanta
Atlanta
Atlanta
Page Break
Boston
Boston
Page Break
Chicago
Chicago
View 9 Replies
View Related
Mar 25, 2014
Say I have Source Workbook X 1, and Destination Workbooks X 4. The Source workbook contains a number of lookup values. I want the lookup values to be maintained in the single Source workbook, and I want this workbook to remain closed when the end users are using their Destination workbooks. It is critical that certain cells in the Destination workbooks have validated data in order for formulas and summarizations to be correct.
I'm happy if the Destination workbooks contain a lookup worksheet (perhaps hidden). In short, I'd like the contents from the Source workbook, Lookups worksheet, to just be replicated "as is" into the Destination workbooks, Lookups worksheet. I then want to do my data validation from that worksheet, which of course is open (data validation appears to only work with open workbooks).
I've investigated the techniques in this link: [URL]
Questions:
1) Are the techniques in that link about the best approach? i.e. an external link plus array formulas?
2) A blank cell in the source workbook (text column but formatted as General) is resulting in a zero in the external link. How can I make the external link exactly match the text as entered in the source workbook?
View 5 Replies
View Related
Jul 8, 2013
getting printed output to page break when the value in a sorted column changes. My spreadsheet is a basic list where one column identifies a responsible organization. I need the output to page break when the responsible organization changes.
View 1 Replies
View Related
Mar 18, 2009
I want to create an automatic page break at each value change in Column A, and also a page footer that "restarts" at each change in the same column.
For example, I would like a "Page x of y" footer, but I don't want "Page 1 of 3,500", I want "Page 1 of 3", etc...every time that Column A value changes.
View 9 Replies
View Related
Jun 14, 2007
My spreadsheet has multiple charts, each referencing a dynamic named range as its source data (e.g. "California1", "California2", etc). Each named range contains multiple series. I would like to make it easy for a single chart to quickly adjust to display different named ranges (e.g. view the chart with "California1" data, then update the same chart to view "California2" data).
I'd like to do this without having to right-click on the chart, select Source Data, and then type in "California2" as the Data Range. My question: is there a way to make the chart's Source Data Range dynamic so that I can quickly select the named range that I want to display? For example, would it be possible to tie the Data Range to a separate cell so that if I typed "California2" into that cell the chart would know to use that named range as its new source data?
View 7 Replies
View Related
Aug 9, 2007
I have an excel addin that contains chart templates. Without going into too much detail a user will select an option which will update these templates then move the charts along with the source data to a new workbook. My question is this; How do I change the chart references programatically so that the chart data now points to the source data in the new workbook.
View 5 Replies
View Related
Aug 30, 2007
When attempting to use the following
charts.add
activechart.setsourcedata thisworkbook.worksheets("PTPage1"). range("A1")
I receive the following error: Run-time Error '1004':
The source data of a pivotchart report cannot be changed. You can change the view of data in a pivotchart report by reorganizing its fields or items, or by changing its associated PivotTable report.
View 2 Replies
View Related
Nov 26, 2013
Am currently working on an excel sheet that has values in multiple columns and rows. Simple example would be like
Assume two columns , with column One having a dropdown list to select the value ,
Pencil 2
Paper 3
Pencil 3
Eraser 3
Pencil 3
I want the data to be created in another sheet as
Pencil - 8
Paper - 3
Eraser - 3
I understand that this can be done through pivot table but the issue is when I change the quantity of the item in the source , say reduce pencil by 1 , the same should be reflected in the summation sheet as well automatically .
View 5 Replies
View Related
Feb 9, 2012
I have a worksheet with many pivot tables and (eventually) 2 data sheets. I run a macro that creates the first pivot table and copies it 17 times. Then, using Call, I would like it to create the second data table, "Credits" (I'm working on that, but that's a seperate issue). Finally, I want one of the existing PT to change to the new data, "Credits".
I'm using an named range and that seems to be where I'm breaking.
Code:
Sub Remove_Credits()
'
Dim CSD As Worksheet
[Code].....
View 4 Replies
View Related
Mar 8, 2013
I have a Pivot table which is created by running a macro with formula calculated columns.
Q1. when i add another column in data sheet, and change the source manually, i get a error in calculated columns
Q2. I need to add the new column in data sheet to the row labels of the existing pivot sheet. with change formula calculated columns.
Q3. can we have any macro to this ?
View 3 Replies
View Related
Apr 17, 2013
I have an 'in-cell dropdown' which looks up two values, Q1 and Q2 I have a range of data by month showing a specific number as below e.g
Month
Count
2012-01
120
2012-02
190
2012-03
200
2012-04
150
2013-05
175
I have a Line graph using this entire table as the source data. What I would like to do is only use part of the data based on what the dropdown cell specifies. For example, if it is set to "Q1", I would like just the 2012-01 and 2012-02 data to show in the graph. If its "Q2", I would like only 2013-03 and 2012-04 data to show in the graph.
View 4 Replies
View Related
Jun 12, 2007
I have a workbook with a number of pivot tables as well as the source data for each pivot table. Some of the source data sheets needed to be deleted so now if I try to refresh the corresponding pivot table I get "Connot open pivot table source file '[Std Mthly Rpt.xls]Report_2'". I recreated the source file again and would like to know if I can link the pivot table to this new source file or do I need to create a new pivot table??
View 7 Replies
View Related
Jul 16, 2007
I am in the middle of building a macro for some data to be automated. I have two sheets, one of which has an existing chart but the data has been removed so now there is no values on the chart. I then have a second sheet with data on it. The range is b4:c16. I want to point this data onto my chart on the other sheet.
View 2 Replies
View Related
Aug 1, 2008
I have fond a couple of posts to achieve this however they all require selecting the picture first. Is there a way to change the picture formula without selecting the picture?
View 8 Replies
View Related
