updates

Hi, I've got some SumIFS, and CountIFS when my sheet updates it's links to other sheets, that should have no impact on the forumla's the 2 previous mentioned formula's seem to corrupt. The formula's work if i choose not to update the sheet, and also work if i open the sheet after i update the...

I am looking for a way to track the last updated version of pdf Files in another folder that I have linked to a power pivot. I saw threads about tracking last updates on sheets themselves but wasn't sure if there was anyway to track back updates/edits made on files in a different folder? Thanks...

Hello- I have created a spilt DB for users who will be using different forms from the front end database. I have come to find out that when updates are made to the backend database they will not transfer to the front end database unless the backend database is saved on a shared network. The...

Hello, I'm receiving real time power data that is updating every 10 minutes in cells E15,F15. Every time it updates the current values disappear and are replaced with the new values. I would like to record all of the values throughout the day so I can work with the data later. What I would...

Hi, I am struggling with this (sorry). In the past I have managed to create a textbox in Excel and link this to a cell in Excel such that when the formula in the cell updates the text updates as well. Unfortunately I can't get this to work ...when I type = and try to link to a call it just...

So turns out that since I have a subscription download of Office Pro Plus 2016, the version is ancient and there's a lot of new updates made that I'd like to install. How do I do that? File -> Account -> Office Updates -> Update Options -> Update Now says I have the newest version while clearly...

This currently is attached to a field and when it changes to a name it updates the pivot tables written in it, it only changes the filters, how can I have it change the row filter instead of the master filter? Set pt = Worksheets("TPPE Summary Level").PivotTables("VLQP") Set Field =...

Hi, I need some help with the following VBA. I'm using this to update pivot filters based on cell values located in H6:H7. As the values in this range are updated it automatically updates the filters on the pivot. However, the auto update doesn't work if H6:H7 are formulas themselves. If the...

I have created a data log in excel that shows all of the changes that have been made in my workbook. How would i create a line graph that just tracks the changes in some of the cells, that also automatically updates when one a change is added to my log? Thanks.

Hi all, Recent Office security updates has broken ActiveX controls on worksheets .. The usual and rather long-winded fix (Which may not always work) is to locate all exd files and delete them or install the following updates. Here, I took a different approach. I added the ActiveX controls (In...

I use excel 2016 on win 10 pro. I have a workbook that when data is entered on one sheet it updates rows on another sheet. What I'm wondering is how to make it so that after data is entered it locks then moves to the next row and sheet 1 can have new data entered and it updates on sheet 2 in row...

Hi All I have a dropdown in a sheet that just updates my sheet as soon as the user changes a date The problem I have that every time I change the dropdown box - I get this message "You're selecting something that doesn't exist yet...try again..." but the actual figures and everything still...

How do I have a live date in a cell in excel that whenever I open up the workbook the date updates itself automatically to the current date? Thanks:confused:

I have a Macro which was working fine for months and about a week ago I got a message to say there were updates which needed to be applied to office home and business 2016. Following the updates the macro crashes I recorded the actions again from scratch and saved to a new macro. This also...

Hello all, I have a directory that contains monthly lead reports - one Excel spreadsheet per month. I have an aggregated spreadsheet that takes all the data from each of the monthly spreadsheets to show all the data for all months. I do this by using the "get data" -> from file -> from folder...

Hi Folks I've taken web data from sky sports for the premiership I want to extract the news alerts as the page updates I've tried H lookup to find Bournemouth News and return the information in the next cell but I get N/A =HLOOKUP(Bournemouth!S53,B49:B68,2,0) Looking forward to your answer...

Good morning All, I have a file that has several tabs of information that multiple people have access to update at the same time. When I get the message "Your workbook has been updated by others", is there a way for that message to show me exactly what was updated so that I don't have to go...

Hello, How can a recordset of data from a database or someplace else be copied / overwritten into an existing Table in Excel 2016. Thank you dear All for your help.

I have a long list of names in a pivot table, I am trying to standardize the names and every time I refresh, the edits I have made go to the BOTTOM of the list! This is maddening. I just want the list to stay the same and show the list in its original order with the edits in place. The edits are...

So I have a what I think is very weird inconsistency in my excel workbook. Whenever I update my data the latest day I update for the very first row is always wrong. Now this doesn't effect much in turns of data integrity it is still about 99.9% accurate from the supplied source. The reason why...