MrExcel.com - Your One Stop for Excel Tips & Solutions

Published Excel Files

Posted by Don on December 27, 2001 3:42 PM

I have "published" an Excel file to our web site for viewing by the sales team, but would like to allow them to make changes to the file (add status of a sales lead, say) and have the published file updated without having to FTP a new file to the web server. Does anybody know if this can be done?

Thanks.

Posted by Joe Was on December 28, 2001 6:50 AM

Ok, then how about using if(isna to replace the na with the actual Text "N/A"? The Min calculation will ignore text.

Posted by Joe Was on December 28, 2001 7:16 AM

Put this topic into the Excel Help: Put Microsoft Excel data on a Web page. Then select: Worksheet from the list "Data that will be interactive."

This topic gives step-by-step instructions on how to have other people update your file on the web. JSW