automatic updates

Hi, I have created a simple report in BI by using data from a folder. In short, I get a new file everyday that I want to add to my report. This works fine when I press the update button in Power BI Desktop. But.. what I want is to get it updated automatically. I can't find a working way to...

Hello, I am a long time forum user but have never had to post before (lucky me!). I am reasonably good with excel but have zero macro/programming knowledge. I have a excel sheet that details pricing information for some raw materials. These are updated daily. I would like to schedule this...

Just throwing this out there if anyone has any good recommendations - at my work, we have (what I imagine is a problem at any number of small to large companies) a lot of exclusive [HR] databases and spreadsheets that had great, ambitious intentions, that just don't talk to one another. As you...

Hi All, I've never asked the board for help directly before as I've always been able to find answers in reply to other posters' questions! This time I am truly stumped. I've got a spreadsheet that lists employee hours worked by week, I'm trying to create a function that would give an...

Hi all I have a workbook with a management dashboard - let's call it the central workbook - that collates commissions and performance data for our sales people from various other workbooks which are managed by leaders. Currently, we keep all of the aforementioned workbooks in a folder that only...