Been having this problem with my website not displaying updated CSS files.
The last time I had this problem, I ended up erasing my S3 bucket and CloudFront distribution, and re-creating the whole bucket & distribution with new names. Now the problem is re-occuring. Whenever I make changes to the site's CSS file, the files on the CloudFront is not updated. If I type in the file path manually, I can see that the CSS file has been updated on the S3 storage, but not on the CloudFront end.
So the file from S3 is not synchronized on the CloudFront. Any help is appreciated. Right now the only way I can make the site appear correctly is by turning off CDN/CloudFront.
I'm using Wordpress 2.9 with W3 Total Cache plug-in. I don't think that the problem is on the Wordpress and the Total Cache plug-in, as they did their job to upload the updated CSS file into S3 storage.
I did try waiting out for ~24hours, perhaps it is a cache issue somewhere, but apparently not.