linked

Hello i have created multiple pivot tables from 1 table source i have created 1 pivot table linked to another data source the tables are pretty much identical except a few fields is there a way I can link all the slivers to the other 1 pivottable without using power pivot as the not all...

Hi, I'm new to this forum, so I am glad I found you all and hope you can help. I have a workbook where I record monthly stock data. this data is linked to other worksheets and some other workbooks where I have formula's to do various calculations. The way I link them is using the "=" and...

Hi everyone Hope someone can help. How do I format a textbox to show 1.0 with 1 decimal point....It shows correctly in excel but not on a textbox that is linked to it. Thank you for any help with this Textbox2.Value =Format(Val(Textbox2.Value) /Range ("T1") , 0.0))

I need to create formula to count the number of rows on my spreadsheet that contain formulas (Sheet B). I have section that contains "hard-coded" records. This are hard coded in gray. I then, after the last gray row, I have all the following rows linked to another sheet (Sheet A). I need to...

Hi frnd, Can we create read-only Linked table , so that user won't able to delete/update anything table. below code works, but it doesn't create readonly access. Any help would be appreciated. DoCmd.TransferDatabase TransferType:=acLink, _ DatabaseType:="Microsoft Access", _...

Hi all We've got various SharePoint lists for pieces of work being actively worked on and I want to link to ours in Access 2016 (.accdb format) to save using the web interface and keep all our stuff in one place (we use the same Access database for other things). I've linked the list to Access...

Hi I am new to VBA and I was hoping you could help me with the following. I am trying to write a code to help me insert multiple (about 100) pdf files to different worksheets and name the worksheets as the pdf file they contain. Also create a linked index as the main page with the filenames...

Good day all, Please i need your collective help with this small excel database which i created. I have an excel workbook with lot of worksheets linked to one sheet in the workbook and also linked to other workbook, but whenever i delete a record by deleting the whole row, it affects all linked...

Hello All, I have successfully created a searchable drop down box using the ActiveX Combo Box tool. Under Properties there is a "linked cell" row. I am not able to identify more than one at a time. Does anybody have a solution for using multiple cells and/or a different approach to creating...

I haven't done this yet but there is a possibility that I will have to create a master file which is linked to 5 separate Excel files. We have members that don't occur in our Members database and need to manually added to our Excel files so they show up in our Leadership reports. I created an...

Hi, I have a summary workbook linked to 4 data entry workbooks. All workbooks are used throughout the day by different people and saved periodically. The linked cells do not update when using the "Refresh All" button on the Data ribbon. However, they do update when closing the summary workbook...

I have a workbook containing data referring to the progress of my shares which is linked to a website which contains a table of historical data relating to the closing price of the shares. Unfortunately the web page does not remain static which means that the formulas in my spreadsheet do not...

I have two tables in Excel 2016 powerpivot. One is coming from an access database and has 500,000+ rows, [Invoices]. The second is a linked table within the excel document, [New_Prices]. The idea is to enter in new pricing in the linked table, and refresh the pivot table so that it reflects...

Hi there, I seem to have trouble that I haven't had before and may be that I'm not using the full functionality of excel 2016. I have a simple master spreadsheet that is linked to multiple spreadsheets and unless I have the actual linked spreadhseet open, I get the #VALUE ! in the master...

I have an odd error that I haven't been able to figure out with regards to updating the values on a linked spreadsheet. When the sheet opens, its asks if I want to update values and I confirm yes. I have this sheet linked to one other sheet and those values update fine. However, I get an...

Hi all. This may not even be possible. However here is the question. I have a two files on a network share. Call them "Linked Data" and "Local Data". The "Local Data" has Linked rows from "Linked Data" and one column that data is entered. If I add rows into to the source file "Linked Data" it...

I have a spreadsheet (sheet2) that is linked to sheet (sheet1) that is imported from our database. I would like a message alert to pop up to notify me that I have less data on the linked sheet (sheet2) than the sheet that was just imported. Sheet2 is linked to an Access database to run a report...

Is there a way in Access to convert a standalone table to a linked table (without re importing it as a linked table)? I have several tables that I would like to link from Excel To Access. Ordinarily I would import the Excel tables as linked tables but I was wondering if there a quick way of...

Hi all - wondering if someone would be able to assist me. I have a workbook with formulae in multiple sheets referring to other sheets in the same workbook that are quite basic (SUMIFS, COUNTIFS, IF statements, etc) - we'll call this workbook A. There are dynamic ranges and PivotTables as well...

Hi everyone, I am new to this forum, I need HELP!! I have linked an excel cell (A1) to an external source, when ever the value from the source changes the cell will reflect the same value(used Paste Special>Link). Now I need a code which can append all the values of the cell in a different...