This information is pulled in from an external link to a folder. Table A is a table of daily closing share prices. I have two tables: Table A (Where I want specific information inserted into) and Table B (where I am drawing the information from) I have made the formulae as efficient as I can, but Excel has its limits.ĭesired Result (you see there are cumulative formulae – please ignore those, that I not an issue I have right now – maybe later) I have broken off the bulk of the formula into separate files and then only import the result as a table, but I do need to run that big sheet sometimes and it takes a while. Share Prices - This goes on for 32 000 lines at this point - the reason why Excel is slowing down. I have attached screenshots numbered 1 to 4 (below), being The issue is that the volume of data is getting somewhat large and access should be able to process the data quicker. I am trying to perform a function in access that I can quite easily do in Excel in PowerQuery. This is effectively a multiple to multipe. There are no primary cells or unique numbers.
0 Comments
Leave a Reply. |