Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default 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.
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2,836
Default 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.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Need help with refreshing data Cam Excel Discussion (Misc queries) 0 April 15th 08 07:12 PM
Refreshing external data JohnUK Excel Programming 2 October 12th 07 12:56 PM
Refreshing external data JohnUK Excel Programming 5 September 13th 07 12:52 PM
Refreshing Data from a web query smith_gw Excel Discussion (Misc queries) 0 April 25th 07 10:44 PM
Auto refreshing data via VBA Stonewall Rubberbow Excel Programming 1 January 28th 07 02:04 AM


All times are GMT +1. The time now is 04:36 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"