Refreshing data
My company downloads a csv file daily from an external website, we then take
this data and make it look pretty with pivot tables and such every day. Is there anyway we could take the pivot tables and formating of cells and refresh them with the new data daily? I'm a .NET developer and I'm pretty sure I could do it in .NET but there has to be an easier solution. Thanks. |
Refreshing data
Pretty simple:
http://www.ozgrid.com/VBA/pivot-table-refresh.htm I'm trying to learn .NET now. I thought it would be fairly easy. It's not exactly hard, but definitely NOT easy. -- Ryan--- If this information was helpful, please indicate this by clicking ''Yes''. "MarkGMaxim" wrote: My company downloads a csv file daily from an external website, we then take this data and make it look pretty with pivot tables and such every day. Is there anyway we could take the pivot tables and formating of cells and refresh them with the new data daily? I'm a .NET developer and I'm pretty sure I could do it in .NET but there has to be an easier solution. Thanks. |
All times are GMT +1. The time now is 11:35 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com