Help/file: mention the working directory for `ARCHIVE_EXTRACT`

See: https://discourse.cmake.org/t/10135
diff --git a/Help/command/file.rst b/Help/command/file.rst
index 4acdc7e..f373e24 100644
--- a/Help/command/file.rst
+++ b/Help/command/file.rst
@@ -1254,6 +1254,13 @@
 
   ``LIST_ONLY`` will list the files in the archive rather than extract them.
 
+  .. note::
+    The working directory for this subcommand is the ``DESTINATION`` directory
+    (provided or computed) except when ``LIST_ONLY`` is specified. Therefore,
+    outside of script mode, it may be best to provide absolute paths to
+    ``INPUT`` archives as they are unlikely to be extracted where a relative
+    path works.
+
   .. versionadded:: 3.24
     The ``TOUCH`` option gives extracted files a current local
     timestamp instead of extracting file timestamps from the archive.