Microsoft Excel

Part I: Overview of Excel Services - Page 30
Part I: Overview of Excel Services - Page 31
Chapter 1: Introduction to Excel Services - Page 32
Who Hasn’t Heard of Excel? - Page 33
Why Excel on the Server? - Page 34
Why Excel on the Server? - Page 35
Why Excel on the Server? - Page 36
What Is Excel Services? - Page 37
Microsoft Office SharePoint Server - Page 38
Microsoft Office SharePoint Server - Page 39
Microsoft Office SharePoint Server - Page 40
Microsoft Office SharePoint Server - Page 41
Microsoft Office SharePoint Server - Page 42
Microsoft Office SharePoint Server - Page 43
Microsoft Office SharePoint Server - Page 44
Microsoft Office SharePoint Server - Page 45
Microsoft Office SharePoint Server - Page 46
Microsoft Office SharePoint Server - Page 47
Microsoft Office SharePoint Server - Page 48
Five Key Ways to Use Excel Services - Page 49
Five Key Ways to Use Excel Services - Page 50
Five Key Ways to Use Excel Services - Page 51
Five Key Ways to Use Excel Services - Page 52
Five Key Ways to Use Excel Services - Page 53
Five Key Ways to Use Excel Services - Page 54
Who Is Excel Services For? - Page 55
What Excel Services Is Not - Page 56
Summary - Page 57
Chapter 2: Getting Started with Excel Services - Page 58
Platform Requirements - Page 59
Platform Requirements - Page 60
Excel 2007 Client - Page 61
Excel 2007 Client - Page 62
Excel 2007 Client - Page 63
Excel 2007 Client - Page 64
Excel 2007 Client - Page 65
Excel 2007 Client - Page 66
After Setup Completes - Page 67
After Setup Completes - Page 68
After Setup Completes - Page 69
After Setup Completes - Page 70
Summary - Page 71
Summary - Page 72
Summary - Page 73
Chapter 3: Architecture - Page 74
Chapter 3: Architecture - Page 75
Understanding the Architecture - Page 76
Understanding the Architecture - Page 77
Understanding the Architecture - Page 78
Understanding the Architecture - Page 79
Understanding the Architecture - Page 80
Understanding the Architecture - Page 81
Understanding Operational Concepts - Page 82
Understanding Operational Concepts - Page 83
Understanding Operational Concepts - Page 84
Understanding Operational Concepts - Page 85
Understanding Operational Concepts - Page 86
Understanding Operational Concepts - Page 87
Understanding Operational Concepts - Page 88
Understanding Operational Concepts - Page 89
Understanding Operational Concepts - Page 90
Understanding Operational Concepts - Page 91
Understanding Operational Concepts - Page 92
Optimizing for Performance - Page 93
Optimizing for Performance - Page 94
Optimizing for Performance - Page 95
Optimizing for Performance - Page 96
Optimizing for Performance - Page 97
Optimizing for Performance - Page 98
Optimizing for Performance - Page 99
Summary - Page 100
Summary - Page 101
Part II: Working with Excel Services - Page 102
Part II: Working with Excel Services - Page 103
Chapter 4: Workbook Support - Page 104
Unsupported Features - Page 105
Unsupported Features - Page 106
Unsupported Features - Page 107
Unsupported Features - Page 108
Unsupported Features - Page 109
Unsupported Features - Page 110
Unsupported Features - Page 111
Unsupported Features - Page 112
Unsupported Features - Page 113
Unsupported Features - Page 114
Par tially Supported Features - Page 115
Par tially Supported Features - Page 116
Par tially Supported Features - Page 117
Par tially Supported Features - Page 118
Summary - Page 119
Chapter 5: External Data - Page 120
Connecting to Data - Page 121
Connecting to Data - Page 122
Connecting to Data - Page 123
Connecting to Data - Page 124
Connecting to Data - Page 125
Connecting to Data - Page 126
Connecting to Data - Page 127
Security - Page 128
Security - Page 129
Security - Page 130
Security - Page 131
Security - Page 132
Security - Page 133
Security - Page 134
Security - Page 135
Security - Page 136
Security - Page 137
Performance - Page 138
Performance - Page 139
Performance - Page 140
Excel Web Access - Page 141
Excel Web Access - Page 142
Excel Web Access - Page 143
Excel Web Access - Page 144
Common Configuration - Page 145
Summary - Page 146
Summary - Page 147
Chapter 6: Capacity and Deployment Planning - Page 148
Chapter 6: Capacity and Deployment Planning - Page 149
Chapter 6: Capacity and Deployment Planning - Page 150
Chapter 6: Capacity and Deployment Planning - Page 151
Chapter 6: Capacity and Deployment Planning - Page 152
Chapter 6: Capacity and Deployment Planning - Page 153
Chapter 6: Capacity and Deployment Planning - Page 154
Capacity Planning - Page 155
Capacity Planning - Page 156
Capacity Planning - Page 157
Capacity Planning - Page 158
Capacity Planning - Page 159
Capacity Planning - Page 160
Capacity Planning - Page 161
Capacity Planning - Page 162
Capacity Planning - Page 163
Capacity Planning - Page 164
Capacity Planning - Page 165
Capacity Planning - Page 166
Summary - Page 167
Chapter 7: Administration of Excel Services - Page 168
Chapter 7: Administration of Excel Services - Page 169
Chapter 7: Administration of Excel Services - Page 170
Chapter 7: Administration of Excel Services - Page 171
Chapter 7: Administration of Excel Services - Page 172
Chapter 7: Administration of Excel Services - Page 173
Chapter 7: Administration of Excel Services - Page 174
Chapter 7: Administration of Excel Services - Page 175
Chapter 7: Administration of Excel Services - Page 176
Chapter 7: Administration of Excel Services - Page 177
Chapter 7: Administration of Excel Services - Page 178
Chapter 7: Administration of Excel Services - Page 179
Chapter 7: Administration of Excel Services - Page 180
Chapter 7: Administration of Excel Services - Page 181
Chapter 7: Administration of Excel Services - Page 182
Chapter 7: Administration of Excel Services - Page 183
Chapter 7: Administration of Excel Services - Page 184
Chapter 7: Administration of Excel Services - Page 185
Chapter 7: Administration of Excel Services - Page 186
Chapter 7: Administration of Excel Services - Page 187
Chapter 7: Administration of Excel Services - Page 188
Chapter 7: Administration of Excel Services - Page 189
Chapter 7: Administration of Excel Services - Page 190
Chapter 7: Administration of Excel Services - Page 191
Chapter 7: Administration of Excel Services - Page 192
Chapter 7: Administration of Excel Services - Page 193
Chapter 7: Administration of Excel Services - Page 194
Chapter 7: Administration of Excel Services - Page 195
Chapter 7: Administration of Excel Services - Page 196
Chapter 7: Administration of Excel Services - Page 197
Monitoring - Page 198
Monitoring - Page 199
Monitoring - Page 200
Monitoring - Page 201
Monitoring - Page 202
Monitoring - Page 203
Monitoring - Page 204
Monitoring - Page 205
Monitoring - Page 206
Monitoring - Page 207
Monitoring - Page 208
Monitoring - Page 209
Monitoring - Page 210
Monitoring - Page 211
Monitoring - Page 212
International Deployments - Page 213
International Deployments - Page 214
International Deployments - Page 215
International Deployments - Page 216
International Deployments - Page 217
International Deployments - Page 218
Summary - Page 219
Chapter 8: Security - Page 220
Chapter 8: Security - Page 221
Chapter 8: Security - Page 222
Chapter 8: Security - Page 223
Chapter 8: Security - Page 224
Chapter 8: Security - Page 225
Chapter 8: Security - Page 226
Protecting Against Attacks - Page 227
Protecting Against Attacks - Page 228
Protecting Against Attacks - Page 229
Protecting Against Attacks - Page 230
Protecting Against Attacks - Page 231
Protecting Against Attacks - Page 232
Protecting Against Attacks - Page 233
Protecting Against Attacks - Page 234
Protecting Against Attacks - Page 235
Protecting Against Attacks - Page 236
Protecting Against Attacks - Page 237
Summary - Page 238
Summary - Page 239
Part III: How-To Scenarios - Page 240
Part III: How-To Scenarios - Page 241
Chapter 9: Sharing Workbooks with the Browser - Page 242
Chapter 9: Sharing Workbooks with the Browser - Page 243
Chapter 9: Sharing Workbooks with the Browser - Page 244
Chapter 9: Sharing Workbooks with the Browser - Page 245
Chapter 9: Sharing Workbooks with the Browser - Page 246
Chapter 9: Sharing Workbooks with the Browser - Page 247
Chapter 9: Sharing Workbooks with the Browser - Page 248
Chapter 9: Sharing Workbooks with the Browser - Page 249
Chapter 9: Sharing Workbooks with the Browser - Page 250
Chapter 9: Sharing Workbooks with the Browser - Page 251
Chapter 9: Sharing Workbooks with the Browser - Page 252
Chapter 9: Sharing Workbooks with the Browser - Page 253
Viewing Workbooks in the Browser - Page 254
Viewing Workbooks in the Browser - Page 255
Viewing Workbooks in the Browser - Page 256
Viewing Workbooks in the Browser - Page 257
Summary - Page 258
Summary - Page 259
Chapter 10: Interacting with Workbooks in the Browser - Page 260
Navigating Workbooks and Hyperlinks - Page 261
Navigating Workbooks and Hyperlinks - Page 262
Navigating Workbooks and Hyperlinks - Page 263
Navigating Workbooks and Hyperlinks - Page 264
Navigating Workbooks and Hyperlinks - Page 265
Navigating Workbooks and Hyperlinks - Page 266
Navigating Workbooks and Hyperlinks - Page 267
Navigating Workbooks and Hyperlinks - Page 268
Using Tables to Sor t and Filter Data - Page 269
Using Tables to Sor t and Filter Data - Page 270
Using Tables to Sor t and Filter Data - Page 271
Using PivotTables - Page 272
Using PivotTables - Page 273
Using PivotTables - Page 274
Working with Workbook Parameters - Page 275
Working with Workbook Parameters - Page 276
Working with Workbook Parameters - Page 277
Working with Workbook Parameters - Page 278
Working with Workbook Parameters - Page 279
Interactivity and Char ting - Page 280
Interactivity and Char ting - Page 281
Interactivity and Char ting - Page 282
Interactivity and Char ting - Page 283
Interactivity and Char ting - Page 284
Excel Web Access Interactivity Settings - Page 285
Summary - Page 286
Summary - Page 287
Chapter 11: Controlling Workbook Distribution - Page 288
Chapter 11: Controlling Workbook Distribution - Page 289
Chapter 11: Controlling Workbook Distribution - Page 290
Chapter 11: Controlling Workbook Distribution - Page 291
Chapter 11: Controlling Workbook Distribution - Page 292
Chapter 11: Controlling Workbook Distribution - Page 293
Chapter 11: Controlling Workbook Distribution - Page 294
Chapter 11: Controlling Workbook Distribution - Page 295
Chapter 11: Controlling Workbook Distribution - Page 296
Chapter 11: Controlling Workbook Distribution - Page 297
Chapter 11: Controlling Workbook Distribution - Page 298
Chapter 11: Controlling Workbook Distribution - Page 299
Chapter 11: Controlling Workbook Distribution - Page 300
Chapter 11: Controlling Workbook Distribution - Page 301
Chapter 11: Controlling Workbook Distribution - Page 302
Chapter 11: Controlling Workbook Distribution - Page 303
Chapter 11: Controlling Workbook Distribution - Page 304
Chapter 11: Controlling Workbook Distribution - Page 305
Chapter 11: Controlling Workbook Distribution - Page 306
Controlling Workbook Viewing - Page 307
Controlling Workbook Viewing - Page 308
Controlling Workbook Viewing - Page 309
Controlling Workbook Viewing - Page 310
Controlling Workbook Viewing - Page 311
Controlling Workbook Viewing - Page 312
Controlling Workbook Viewing - Page 313
Controlling Workbook Viewing - Page 314
Controlling Workbook Viewing - Page 315
Controlling Workbook Viewing - Page 316
Controlling Workbook Viewing - Page 317
Controlling Workbook Viewing - Page 318
The End-to-End Scenario - Page 319
The End-to-End Scenario - Page 320
Summary - Page 321
Chapter 12: Business Intelligence Solutions - Page 322
Chapter 12: Business Intelligence Solutions - Page 323
Chapter 12: Business Intelligence Solutions - Page 324
Chapter 12: Business Intelligence Solutions - Page 325
Chapter 12: Business Intelligence Solutions - Page 326
Chapter 12: Business Intelligence Solutions - Page 327
Chapter 12: Business Intelligence Solutions - Page 328
Chapter 12: Business Intelligence Solutions - Page 329
Chapter 12: Business Intelligence Solutions - Page 330
Chapter 12: Business Intelligence Solutions - Page 331
Chapter 12: Business Intelligence Solutions - Page 332
Chapter 12: Business Intelligence Solutions - Page 333
Chapter 12: Business Intelligence Solutions - Page 334
Chapter 12: Business Intelligence Solutions - Page 335
Chapter 12: Business Intelligence Solutions - Page 336
Chapter 12: Business Intelligence Solutions - Page 337
Chapter 12: Business Intelligence Solutions - Page 338
Chapter 12: Business Intelligence Solutions - Page 339
Chapter 12: Business Intelligence Solutions - Page 340
Chapter 12: Business Intelligence Solutions - Page 341
Chapter 12: Business Intelligence Solutions - Page 342
Chapter 12: Business Intelligence Solutions - Page 343
Chapter 12: Business Intelligence Solutions - Page 344
Chapter 12: Business Intelligence Solutions - Page 345
Business Intelligence Everywhere - Page 346
Working with SQL Server Analysis Services - Page 347
Working with SQL Server Analysis Services - Page 348
Working with SQL Server Analysis Services - Page 349
Working with SQL Server Analysis Services - Page 350
Working with SQL Server Analysis Services - Page 351
Working with SQL Server Analysis Services - Page 352
Working with SQL Server Analysis Services - Page 353
Working with SQL Server Analysis Services - Page 354
Working with SQL Server Analysis Services - Page 355
Working with SQL Server Analysis Services - Page 356
Working with SQL Server Analysis Services - Page 357
Summary - Page 358
Summary - Page 359
Chapter 13: Offloading Workbook Calculation to the Server - Page 360
Setup and Configuration Considerations - Page 361
Setup and Configuration Considerations - Page 362
Sample Solution Designs - Page 363
Integrating with Windows Compute Cluster Server 2003 - Page 364
Integrating with Windows Compute Cluster Server 2003 - Page 365
Chapter 14: Building Custom Solutions - Page 366
Chapter 14: Building Custom Solutions - Page 367
Chapter 14: Building Custom Solutions - Page 368
Chapter 14: Building Custom Solutions - Page 369
Chapter 14: Building Custom Solutions - Page 370
Chapter 14: Building Custom Solutions - Page 371
Web Service API Methods - Page 372
Web Service API Methods - Page 373
Web Service API Methods - Page 374
Web Service API Methods - Page 375
Web Service API Methods - Page 376
Web Service API Methods - Page 377
Web Service API Methods - Page 378
Web Service API Methods - Page 379
Web Service API Methods - Page 380
Web Service API Methods - Page 381
Web Service API Methods - Page 382
Web Service API Methods - Page 383
Web Service API Methods - Page 384
Web Service API Methods - Page 385
Web Service API Methods - Page 386
Web Service API Methods - Page 387
Web Service API Methods - Page 388
Web Service API Methods - Page 389
Web Service API Methods - Page 390
Web Service API Methods - Page 391
Web Service API Methods - Page 392
Web Service API Methods - Page 393
Web Service API Methods - Page 394
Web Service API Methods - Page 395
User-Defined Functions (UDFs) - Page 396
User-Defined Functions (UDFs) - Page 397
User-Defined Functions (UDFs) - Page 398
User-Defined Functions (UDFs) - Page 399
User-Defined Functions (UDFs) - Page 400
User-Defined Functions (UDFs) - Page 401
User-Defined Functions (UDFs) - Page 402
User-Defined Functions (UDFs) - Page 403
User-Defined Functions (UDFs) - Page 404
Xlviewer Customizations - Page 405
Xlviewer Customizations - Page 406
Xlviewer Customizations - Page 407
EWA and API Working Together - Page 408
EWA and API Working Together - Page 409
EWA and API Working Together - Page 410
EWA and API Working Together - Page 411
EWA and API Working Together - Page 412
EWA and API Working Together - Page 413
EWA and API Working Together - Page 414
EWA and API Working Together - Page 415
EWA and API Working Together - Page 416
EWA and API Working Together - Page 417
Summary - Page 418
Summary - Page 419
Appendix A: Troubleshooting - Page 420
Appendix A: Troubleshooting - Page 421