excel training microsoft - excel web publishing

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel training microsoft - Excel web publishing

excel training microsoft - Excel web publishing

resolvedResolved · Low Priority · Version Standard

Micheal has attended:
Excel Advanced course

Excel web publishing

when using a published excel page over the internet, can you save changes to the server? Or is it only local changes from the page to your pc?

RE: excel web publishing

If you saved the original file from excel on the webserver, you can update automatically by choosing the AUTOREPUBLISH OPTION


 

Excel tip:

Generate randon numbers

Some types of analysis require you to use randomly generated numbers. You can also use randomly generated numbers to quickly populate an Excel spreadsheet. There's an easy function you can use to do this automatically. Here are a few of the ways you can use it:

Type =RAND() in a cell to generate a number between 0 and 1.
Type =RAND()*100 to generate a number between 1 and 100.

View all Excel hints and tips


Server loaded in 0.09 secs.