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

Excel files with Power Query or Power Pivot: what works in Euro-Office and what doesn't

Many businesses have Excel reports that fill themselves: a sales overview that pulls data from the till system, a timesheet report that reads a folder of exports every month, or a pivot table based on a large data model. In Excel, this is called Power Query (getting and transforming data) and Power Pivot (the data model, with DAX formulas). If you put a file like this in your WebOké Nextcloud, the question is: does it also work in Euro-Office?

The honest answer

No. Euro-Office has no Power Query, no Power Pivot, no data model and no DAX. You can open such a file and look at the figures: you see the values as they were last retrieved in Excel. You can't refresh them.

What happens to the queries if you edit the file in Euro-Office? We checked this in the demo with an xlsx containing a data connection and a query table, like the ones Power Query creates: after a change and saving in Euro-Office, the connection and the query table were still in the file. But a real report from Excel can contain much more, such as a Power Pivot data model, and there are reports elsewhere of parts of it being lost after saving. In any case, Euro-Office can't display, check or refresh these parts. So treat a file like this as an Excel file: viewing is fine, but make your edits in a copy or in Excel.

How to recognise such a file

  • In Excel, there is a list of queries under Data, or Excel asks when opening whether you want to refresh the data.
  • There are worksheets with a table that fills "by itself", and nobody types in it.
  • Pivot tables are based on a "data model" instead of a range in the file.
  • Ask the person who made it. If you're not sure, treat the file as one with queries.

How to work: Excel and Euro-Office side by side

Example: Bloemisterij Het Zonnetje has a monthly report that the bookkeeper updates in Excel. The owner wants to view the figures in the browser.

  1. View only. Opening and reading works fine. Don't change anything: Euro-Office saves every change automatically (see Saving: how automatic saving works).
  2. If you want to change something or add calculations, make a copy first: open the file, click File and choose Save Copy As, or copy the file in your Nextcloud. Work in the copy. The original stays for Excel.
  3. Share the original as read-only with colleagues who don't use Excel (see Sharing a document with a colleague), so nobody edits it in Euro-Office by accident.
  4. Updating is done by the creator in Excel on their own computer, using the Nextcloud desktop app (see Working with the Nextcloud desktop app (synchronisation)).

Switching without Power Query

If you want to be able to update the report entirely in Euro-Office, build it differently:

Pitfalls

  • One click is enough. Automatic saving means that even a small change, such as widening a column, saves the file again. If something goes wrong, restore the previous version from the version history (see Version History: restoring an older version).
  • Excel and Euro-Office at the same time: if the bookkeeper works in Excel via the desktop app while you open the file in the browser, you end up with two versions. Agree on who works in the file and when (see Saving or syncing isn't working).
  • Macros: if the file also contains VBA macros (xlsm), read An Excel file with VBA macros: what now? as well.

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…