DBS Send Scope in Slice
In Slice, the DBS Send button on the ribbon sends data for the current worksheet only. There is no setting that changes that specific button to operate across the entire workbook.
If you need workbook-wide behavior, use either the workbook setting described below or trigger the workbook-wide VBA function.
What works at workbook level
Option 1: Use the workbook named range
You can configure the workbook so Slice sends all DBS/DBSW values during a refresh or rebuild cycle.
Create a named range called
SLICEDBSSEND.Set its value to 1.
When the workbook is refreshed or rebuilt, Slice will send data for the workbook automatically.
This is the best option when you want workbook-wide send behavior without relying on users to run sheet-by-sheet actions.
Option 2: Use VBA to send the whole workbook
Slice exposes VBA functions that can be called with Application.Run.
Sub SendCurrentSheet()
Application.Run "DBSSEND"
End Sub
Sub SendWholeWorkbook()
Application.Run "DBSSENDALL"
End SubDBSSEND sends data for the active worksheet. DBSSENDALL sends data for the active workbook.
You can attach the workbook macro to a standard Excel button or include it in a larger automation routine.
Related Slice setting
There is also a user setting in Slice called DBS Send Data on Recalc. When enabled, Slice sends DBS values automatically during recalculation/refresh behavior, and the manual DBS Send button is hidden.
This setting is useful for personal workflow automation, but it is different from changing the scope of the ribbon button itself.
Recommended approach
Need | Recommended approach | Why |
|---|---|---|
Send only the active sheet | Use | Matches the default Slice behavior |
Send the whole workbook on demand | Use | Gives explicit workbook-wide control |
Send workbook data automatically during refresh/rebuild | Create | Enables workbook-level send behavior without manual steps |
Automate sends for a specific user workflow | Enable DBS Send Data on Recalc | Useful when automatic sending is preferred over manual actions |