5 Replies Latest reply on Sep 6, 2011 10:02 AM by philmodjunk

    Excel spreadsheets in containers

    MikeEdwards

      Title

      Excel spreadsheets in containers

      Post

       We have recently experienced a new problem with FM 11. It seems that excel spreadsheets opened out of container fields suddenly and unexpectedly close after 10-30 seconds. This only happens when opening from FM. What up?

        • 1. Re: Excel spreadsheets in containers
          philmodjunk

          I have no idea why, but a bit more info might help others figure this out:

          What Operating system?

          Are the spreadsheets inserted as a file or an object? (Objects are a Windows only option here)

          How are you opening them, by double clicking or using export field contents?

          • 2. Re: Excel spreadsheets in containers
            MikeEdwards

             Windows 7

            Right click to open worksheet.

            • 3. Re: Excel spreadsheets in containers
              philmodjunk

              Are the spreadsheets inserted as a file or an object?

              If you try this on another machine, do you get the same issue?

              • 4. Re: Excel spreadsheets in containers
                MikeEdwards

                 I discovered the root of the problem. I installed a timer script to comit after 60 seconds after keystroke in the layout script trigger. I did this because people would keep FM open on a particular field then throw in down in the doc. I was unable to work on the databse when their page was still open and according to FM working. Was comit the wrong script to use. What trigger could I use so that they could work in Excel out of FM and I can work on the database as a whole?

                • 5. Re: Excel spreadsheets in containers
                  philmodjunk

                  If "work on the database as a whole" means that you are making changes to the design of your database, you shouldn't do that while others are using it. This can create problems for them as well as you. It can also lead to a damaged database file.

                  If you are just doing data entry in other parts of the database, I don't see why another user working in an excel file would lock you out of making data edits in FileMaker.

                  To repeat my earlier question. How is the file inserted? As a file or an Object? How are you opening the inserted file? (there is more than one user action.)

                  Don't really see how commiting a record in FileMaker closes an Excel file, so would like to replicate your exact steps here...