Skip to content

Cookie settings

Choose which kinds of cookies you allow. You can change your choice at any time via Cookie settings at the bottom of every page. Privacy statement

Necessary

Always on

Needed to log in, keep your cart and remember your choices. These are always on.

Which cookies?
  • weboke_sessie, weboke_klant, weboke_remember: your session and staying logged in
  • weboke_basket: your cart
  • wkBtwIncl: showing prices with or without VAT
  • wok_cookies: your cookie choice, 12 months

Measures which ad leads to a visit or order, so we do not pay for ads that do nothing.

Which cookies?
  • Google Ads via Google Tag Manager (_gcl_au, _gcl_aw), up to 90 days
  • OpenAI Ads, ads in ChatGPT
  • wok_aff: which partner referred you to us (affiliate programme), 60 days

4.6

Country and language

Each country has its own site, with prices and VAT for that country.

View

Linking cells to another spreadsheet in your Nextcloud

In Excel, many people refer to another workbook: a quote that takes its prices from the price list, or an annual overview that collects the totals from twelve monthly files. If the price list changes, you update the quote and it's correct again. You can do the same in Euro-Office with files in your WebOké Nextcloud. If the data is on another worksheet in the same file, you don't need this: see A total overview from multiple worksheets: expenses, income and balance and Combining data from multiple worksheets into one list.

Example: Bloemisterij Het Zonnetje has a Prijslijst 2027.xlsx and makes a quote for each wedding. The prices in the quote need to come from the price list.

Creating a link

  1. Open both spreadsheets in your WebOké Nextcloud, each in its own browser tab: the price list (the source) and the quote (the target).
  2. In the price list, select the prices you need, for example B2 to B5, and copy them with Ctrl + C (on a Mac Cmd + C).
  3. Go to the tab with the quote, click the cell where the first price should go (C3) and paste with Ctrl + V. The prices now appear as ordinary numbers.
  4. A small paste options button appears at the bottom right of the pasted cells (1). Click it and choose Paste link (2).
The paste options with Paste link under Other
The paste options button (1) and Paste link (2)

Now click C3. The formula bar no longer shows a number, but a reference to the other file: ='[Prijslijst 2027.xlsx]Prijzen'!B2. The square brackets contain the name of the source file, followed by the worksheet and the cell. Euro-Office also shows a tip saying that the link has been added and that you can update it on the Data tab.

Tip: right after linking, do you see a number aligned to the left in a few cells, or #VALUE! in a formula that uses them? Then update the link once (see below). In the demo, everything was correct after that.

Managing the links

In the quote, go to the Data tab and click External links. You'll see a list of the files your spreadsheet refers to, along with their status. Select a source and choose:

  • Update values: fetch the latest values from the selected source. Use the arrow next to it to update all sources at once (Update all).
  • Change source: point the link to another file, for example next year's price list.
  • Open source: open the price list to check something in it.
  • Break links: remove the link. The most recently fetched values stay in place as ordinary numbers.
  • Automatically update data from the linked sources: if you turn this on, Euro-Office fetches the latest values when you open the file.
The External links window with the price list as the source
External links: the price list is listed as a source; use the buttons at the top (1) to update, change or open the source, or to break the link

The price changes: updating

The florist raises the price of the bridal bouquet in the price list from 89 to 95 euros. At first, nothing changes in the quote. This is how you update the quote:

  1. In the quote, go to Data and click External links.
  2. Select the price list and click Update values.
  3. Click Close. The new price appears in the quote and the total is updated immediately.
The quote with the new price of 95 euros for the bridal bouquet
After updating: the bridal bouquet costs 95 euros and the total has been updated

When you open the quote again later, Euro-Office warns you that the workbook contains links to external sources. Choose Update if you want the latest prices, or Don't Update if you want to leave the quote as it is, for example because the customer has already signed for the old price.

The warning on opening with the Update and Don't Update buttons
On opening: Update or Don't Update

Pitfalls

  • Source renamed or moved? Then the link can no longer find the file. Point to it again with Change source.
  • Only within your own Nextcloud. The link works with files in your WebOké Nextcloud that you have access to. If a colleague updates the quote, share the price list with that colleague too.
  • Also using the file in Excel? Euro-Office saves the link the way Excel does, together with the most recently fetched values. But the link points to a folder in your Nextcloud, such as /WebOké/, which Excel on a computer can't find. Break the link if you send the file to someone outside your organisation.
  • Can't see the paste options button? It only appears right after pasting, at the bottom right of the pasted cells. Paste again if you've clicked it away. Paste with the keys Ctrl + V: when you paste from another tab, the Paste button on the toolbar only shows a message about the keyboard shortcuts.
  • Many sources or large sources make a spreadsheet slower. Only link the cells you really need (see also Speed up a slow spreadsheet).

One moment…

Set up your domains

For each domain, arrange the nameservers, the link to your hosting and who becomes the owner.

Loading your domains…