470
We are on FRx Service Pack 11. We are getting "Runtime Error 9: Subscript out of Range" error message when we export one particular report to Excel. We only get this error if we mark to export to Excel with formulas. If we uncheck that box, we do not get the error. All other reports export with formulas fine. Any ideas what could be causing this?
*This post is locked for comments
Searching again for remedies I saw this thread today.
I had tried the compacting databases, altering trees and column and row formats. I also have reports that export with formulas with same footer values. Clearing and re-typing headers and footers even with the same or different values did not help
As Debbie suggested, I removed Footers from the offending reports. Life is good again.
Debbie
Jaymi,
Try this KB Link : https://mbs.microsoft.com/knowledgebase/KBDisplay.aspx?WTNTZSMNWUKNTMMYUTMZWVZSQTWWUNTTQMZRNXKPSSOVRNVROLMVMWQOOTUKWYYVLXPOYSMONXLWWTXOZLSLPXMMRKKYQWZL
KB NO : 112846
Hope it help will help you. Please let me know if you are not able to access above link.
Thanks
Sandip
210.440.9855
Try Compact FRx Database.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,214
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (